Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a large VBA Excel 2003 project that compiles on my and several
other PCs, but doesn't on a single user's PC (which should be an identical build). The compile error highlights an issue with the following... Dim cbrAll as CommandBars .... set cbrAll = Application.VBE.CommandBars I get an 'Error in Loading DLL' returned when I Debug Compile on this user's machine and the second line above is highlighted. (Compiles without any issues on my machine.) Qn: which DLL is it refering to? (am assuming it is C:\Program Files \Common Files\Microsoft Shared\Office11\MSO.dll -- the Office 11 Object Library, but am not sure). I think this holds the Application.CommandBars object, but not the Application.VBE.CommandBars object ?? We both have exactly the items checked with the same priorities in the VBE Tools References: -- VBA -- Excel 11 Object Library -- OLE Automation -- MS Office 11 Object Library -- MS Forms 2.0 Object Library -- MS XML 5.0 Any help much appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Making Application.CommandBars.ExecuteMso method work in 2007 | Excel Programming | |||
Error in CommandBars | Excel Programming | |||
Compile error in my Application | Excel Programming | |||
Compile error in my Application | Excel Discussion (Misc queries) | |||
VBAProject name compile error, not defined at compile time | Excel Programming |