Problem Note 42657: "Code execution has been interrupted" when VBA code performs a double-click in SAS® Financial Management table
 |  |  |  |  |
If you include VBA code in a SAS Financial Management report or form and the code includes a 'double click' action - such as "Workbook_SheetBeforeDoubleClick" - the result might be an error message similar to
Code execution has been interruptedThis is caused by an ESCAPE message being sent to Excel via the application's API to ensure that the double click action does not cause a cell or cells to be put into edit mode.
This ESCAPE message return was needed in earlier releases of Excel, but it might cause the above error message in Excel 2010 and Excel 2007.
This is marked as fixed in release 5.3 of SAS Financial Management.
For additional information please contact SAS Technical Support.
For information on the SAS Financial Management Add-In API for Microsoft Excel, please refer to the SAS Solutions Services Customization Guide.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Financial Management | Microsoft® Windows® for x64 | 5.1 | 5.3 | 9.2 TS2M0 | 9.3 TS1M0 |
| Microsoft Windows Server 2003 Datacenter Edition | 5.1 | 5.3 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 5.1 | 5.3 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 Standard Edition | 5.1 | 5.3 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 for x64 | 5.1 | 5.3 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2008 for x64 | 5.1 | 5.3 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Microsoft Windows XP Professional | 5.1 | 5.3 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Windows Vista | 5.1 | 5.3 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Windows Vista for x64 | 5.1 | 5.3 | 9.2 TS2M0 | 9.3 TS1M0 | ||
A fix for this issue for SAS Financial Management 5.2_M1 is available at:
http://ftp.sas.com/techsup/download/hotfix/HF2/D73.html#42657
Sending {ESCAPE} to Microsoft Excel via the application's SendKeys API is causing some VBA macros to be interrupted in Excel 2007 and 2010.
| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2011-03-10 21:56:27 |
| Date Created: | 2011-03-10 15:06:19 |