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.

Qn: which DLL is it refering to?

maybe VBE6EXT.dll

try adding a reference to this dll, it's description under references is -
Microsoft Visual Basic for Applications Extensibilty 5.3

Regards,
Peter T

"chandb" wrote in message
...
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.

On 27 Aug, 15:45, "Peter T" <peter_t@discussions wrote:
Qn: which DLL is it refering to?

maybe VBE6EXT.dll

try adding a reference to this dll, it's description under references is -
Microsoft Visual Basic for Applications Extensibilty 5.3

Regards,
Peter T

"chandb" wrote in message

...



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.- Hide quoted text -

- Show quoted text -

Thanks Peter, I'll try that on his machine.
Strange though that this compiles on my PC even though I don't have
the Extensibility reference checked.

Can't see why his PC has a different behaviour!

Thanks for your help.