MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Macros Don't run - on some PCs

  Asked By: Jeff    Date: Dec 12    Category: MS Office    Views: 1961

I have an odd issue. I developed a form and it works on many of our
company computers, on some, they are getting a "Compile Error - Can't
Find Project or Library" message. They are using the same version and
service pack of Excel. Also the Date/Time Picker control is not
working for them.

I've never seen this before, any thoughts?



3 Answers Found

Answer #1    Answered By: Luann Schmidt     Answered On: Dec 12

Maybe you're using a component in your code that is available only in
the source computer where you did the code. This happens when you use
DLL's and components available in Microsoft Office 2003 but when ran
in Office 2000 don't find the right component.

Answer #2    Answered By: Garritt Bakker     Answered On: Dec 12

or the other computers might not have the correct libraries
activated? . . . ("Microsoft Shell Controls And Automation" library.
In VBA, Tools menu, References)

You might have already checked that, but just a thought.

Answer #3    Answered By: Cameron Smith     Answered On: Dec 12

In the VBE go to Tools / References and find the one that says "Missing".
(There should be one.)

Didn't find what you were looking for? Find more on Macros Don't run - on some PCs Or get search suggestion and latest updates.