Technote #
Title
45 Microsoft Visual Basic messages are displayed: "Can't find project or library" or "Compile error in hidden module".
Date Updated Category
21-08-07 Excel Add-Ins
Products
[STarStation 2.0][STarStation 2.3]
<

STarStation Excel Add-Ins are compiled using Excel 2000 (Office 9). The earliest version of Excel with which ACS Add-Ins will work is Excel 2000. The Add-Ins are also compatible with Excel Versions 2002 (Office 10) and Excel 2003 (Office 11).

The Excel Add-In which is copied to the STarStation2.3\Excel Plugins folder (default location C:\Program Files\Applied Cytometry Systems\STarStation 2.3\Excel Plugin) by the STarStation 2.3 installation process was incorrectly compiled using Excel 2003.

When the STarStation 2.3 Excel Add-In is configured in the Excel Add-Ins Manager and run, one of the following Visual Basic errors is displayed

This is because a reference for the Excel 2003 (Excel version 11.0) cannot be located when the user is running an earlier version of Excel. To allow the STarStation 2.3 Excel Add-In to function with earlier versions of Excel (Excel 2000 or Excel 2002) users should download an updated version of the Add-In, see below.

The following references are required for full functionality of the STarStation 2.3 Excel Add-In (STarStationImport2.3.xla) and the STarStation 2.0 Data Import Add-In (STarStationImport.xla).

 

Required Reference*
File and Path
Visual Basic for Applications
C:\Program Files\Common Files\Microsoft Shared\VBA\VBA6\VBE6.DLL
Microsoft XML Version 2
< C:\Windows\system32\msxml.dll
OLE Aut
C:\Windows\system32\STDOLE2.TLB
Microsoft Excel Object Library
Excel 2000 (Excel 9.0) C:\Program Files\Microsoft Office\Office\Excel9.olb
Excel 2002 (Excel 10.0) C:\Program Files\Microsoft Office\OFFICE10\Excel.exe
Excel 2003 (Excel 11.0) C:\Program Files\Microsoft Office\OFFICE11\Excel.exe
Microsoft Scripting Runtime
C:\Windows\system32\scrrun.dll
Microsoft Office Object Library
Excel 2000 (Excel 9.0) C:\Program Files\Microsoft Office\Office\MSO9.DLL
Excel 2002 (Excel 10.0) C:\Program Files\Common Files\Microsoft Shared\OFFICE10\MSO.DLL
Excel 2003 (Excel 11.0) C:\Program Files\Common Files\Microsoft Shared\OFFICE11\MSO.DLL

* The reference files are installed during Microsoft Office Installation and by Windows Updates.

Latest Excel Data Import Add-In Download
Excel Add-In Name
STarStation Version
2.3
2.0

To correct the problem discussed above:

1) Download the relevant Excel Add-In from the table above.

2) Copy the .xla file onto your PC so that the existing Add-In file (STarStationImport.xla or STarStationImport2_3.xla) is overwritten.

 

[ Close Window ]