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 interrupted
This 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
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 |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
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 |