Can't load an object 1

[BostjanPerdan]

Hi!

I get the following message when I try to run my Excel application on some of the computers:
“Could not load an object because it is not available on this machine.”

A VBE window than opens with a message: “Compile error: Can’t find project or library”. This happens with Date object and mid function.

For example:
Dim Today as String
Today = Date

Even stranger is the fact that no problem occurs when I write a test code from scratch on that particular computer, which is otherwise problematic.

Is there a way to import the allegedly missing libraries into Excel. I assume, there might be some ActiveX libraries missing on some of the computers. Though I am not 100% sure this is the source of my problem …

Any useful hints will be appreciated!

Cheers,
Bostjan

 

[PHV]

Check the references in your VBA project:
when in VBE (Alt+F11) menu Tools -> References ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[BostjanPerdan]

PHV,

Thank you for reminding me ... you post has been most helpfull!

Cheers,
Bostjan