Problem Note 39204: Cannot save changes to VBA code in Microsoft Excel .xla files with SAS® Add-In for Microsoft Office
 |  |  |  |  |
After the SAS Add-In for Microsoft Office is installed, changes that you make to VBA code in an .xla file are not saved, even though the file appears to save correctly. When you restart Excel and reopen your .xla file, you see that the saved code changes do not appear.
When the Add-In is uninstalled or turned off, changes to .xla files are saved as expected.
Currently, the only workaround is to turn off the Add-In before updating your VBA code.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Add-in for Microsoft Office | Microsoft® Windows® for x64 | 4.2 | 4.3 | 9.2 TS2M0 | 9.2 TS2M3 |
| Microsoft Windows Server 2003 Datacenter Edition | 4.2 | 4.3 | 9.2 TS2M0 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 4.2 | 4.3 | 9.2 TS2M0 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2003 Standard Edition | 4.2 | 4.3 | 9.2 TS2M0 | 9.2 TS2M3 | ||
| Microsoft Windows XP Professional | 4.2 | 4.3 | 9.2 TS2M0 | 9.2 TS2M3 | ||
| Windows Vista | 4.2 | 4.3 | 9.2 TS2M0 | 9.2 TS2M3 | ||
A fix for this issue for SAS Add-in for Microsoft Office 4.22 is available at:
http://ftp.sas.com/techsup/download/hotfix/HF2/A54.html#39204A fix for this issue for SAS Add-In for Microsoft Office 8.3 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/I8U.html#39204A fix for this issue for SAS Add-In for Microsoft Office for Visual Analytics 8.3 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/I8V.html#39204A fix for this issue for SAS Visual Analytics Add-In for Office 8.3 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/I8V.html#39204| Type: | Problem Note |
| Priority: | high |
| Topic: | Third Party ==> Products ==> Microsoft Office |
| Date Modified: | 2010-04-02 15:06:41 |
| Date Created: | 2010-03-29 15:53:35 |