Revision Date: 04/24/2012
Module: N/A
Version: Macola ES 9.5.X
Description: When opening a Microsoft Excel report using the Excel Add-in,from a Citrix or Terminal Server client an error as shown appears on the screen. This occurs for all databases and Excel reports for the remote client install. This same error occurs when opening Microsoft Excel from a workstation on the LAN.
Solution 1: This article which explains that the error can happen after installing a certain Windows update: http://support.microsoft.com/default.aspx?scid=kb;en-us;932349. The update installs new versions of certain Visual Basic 6.0 Runtime files.
There is a corresponding EXD file that is created for each of the runtime files, when you use the controls provided by the runtime files in the Visual Basic designer. When the runtime files are updated, these EXD files are now invalid and will produce the error shown here. To correct the error, you need to delete the EXD files from the folders listed below. These files will be re-created as needed by the program.
These files should be located in the folder:
On Windows XP:
C:\Documents and Settings\%USERNAME%\Application Data\Microsoft\Forms\
On Windows Vista and Windows 7:
C:\Users\USER\AppData\Microsoft\Forms\
or C:\Users\USER\AppData\Roaming\Microsoft\Forms\
or C:\Users\USER\AppData\Local\Temp\VBE
Alternatively, do a search for *.exd on the C: drive if you are having trouble locating those files in the above location. NOTE: A regular windows search on Windows Server 2003 sometimes does not find these files. If no .exd files are found with a general search, navigate directly to the path indicated above (where USER is replaced by the windows user name) and delete .exd files found there.
Please Note: Additional information may be found in the Microsoft KB article: http://support.microsoft.com/kb/957924/en-us
Another resource that may be helpful in deleting "temporary" files that can be troublesome for Excel: http://www.add-ins.com/temp_file_deleter.htm
Solution 2: If the above does not solve the issue, another step to try:
1. Open the .xls file in question and click OK after getting the error mentioned above.
2. Open the Visual Basic Editor (Alt+F11)
3. Open (if they are not already open) one of the modules or code behind forms
4. Click on Tools / References...
5. In the pop-up window click on Browse...
6. Navigate to [Your Windows Directory]\System32 (it may open by default)
7. Type MSCOMCTL.OCX (you'll see it in the auto-select options before you finish typing)
8. Click Open and the reference will appear as Microsoft Windows Common Controls 6.0 (SP6)
9. Save the file and retry.
Attachments: N/A
Key Words: Object library invalid or contains references to object definitions that could not be found, Microsoft Visual Basic, VBC, Excel
Additional Resource:
Additional knowledgebase documentation - Knowledgebase
FREE on-demand training - Americas Training Start Page