Excel Abort When Starting BoatRecords
On occasion when BoatRecords is started (by clicking on the Records button) Excel 2007 will abort.  Excel 2007 normally will close and restart with the BoatRecords files recovered.  Once this situation occurs it may persist.  Every time BoatRecords is started Excel aborts.  This happens only in the Win7 and Office 2007 environments.  I have not been able to determine the cause of this problem.  Whenever I use the VBA Editor to trap the problem the abort does not happen and in fact normally goes away.  Currently the only way I can clear this condition is to use the VBA Editor.  My guess is that there is a memory allocation bug in Excel 2007 that allows the BoatRecords application to overlay some of the Excel code, producing the abort.  Loading the VBA editor seems to force a different memory allocation and clears the condition.  That's only a guess on my part.  I haven't found any support for that guess on the various Office user forums.   So I'll keep looking for a fix or some support for the Excel bug explanation.
This abort has not happened in the Ofice 2010 environment under Win7.  Nor has it happened when BoatRecordsVBA is installed as an Excel Add-In.
 

1. After loading the BoatRecordsVBA workbook (the Records button is visible in the Excel 2007 ribbon) start the VBA Editor as shown below.

In Excel 2007 the VBA Editor is normally started under the Developer tab on the ribbon as shown on the right.

 

2. Now go back to the Excel Window and click on the Records button to start the application.  As long as sthe VBA Editor is open, there should not be an Excel abort.