View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
chandb chandb is offline
external usenet poster
 
Posts: 2
Default Application.VBE.CommandBars -- Compile error

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.