Compile Error

[bamaisgreat]

I have copied a workbook to another computer and every time I try to run some of the code in it I keep getting all these different Compile Errors. Possible Solutions?

Thanks as always
Jamey

 

[Norie]

Where are you getting the errors?

What are the error messages?

 

[bamaisgreat]

Where are you getting the errors?

What are the error messages?

One is "Cant find project or library"

 

[Joe4]

I assume that the workbook has VBA code.

Are the computers running the same version of Excel?

Also, on the computer that works, open up the VB Editor, click on the Tools menu drop-down and selected References. Make note of all the references that are checked.
Now, do the same on the other computer, and make note of all the references selected there. Are all the same ones checked? If not, you may need to check some. Sometimes, the version numbers might be slightly different, but most of the wording should be the same.

 

[Joe4]

One is "Cant find project or library"

Definitely sounds like the VBA References issue I explained in my previous post.

 

[bamaisgreat]

When I look in the references the only thing i see different is one tho one that is not working it has MISSING in front of Microsoft Windows Common Controls. Could this be it ? If so how do I get it ? Thanks

 

[Joe4]

When I look in the references the only thing i see different is one tho one that is not working it has MISSING in front of Microsoft Windows Common Controls. Could this be it ? If so how do I get it ? Thanks

Yep, that would definitely cause that error message.

You didn't answer the question I asked about if the two computer are using the same version of Excel or not. Sometimes, if you create some VBA code or a newer version and try to run it on an older version, it won't work because you may be using newer features that weren't available in the lower versions. If creating Excel files for multiple users, I always recommend writing it on the oldest version of Excel that any of your users will be using.

In any event, here are some articles that may have you resolve your missing library:
MISSING: Microsoft Windows Common Controls-2 6.0
Missing References In VBA

 

[Norie]

Uncheck the reference(s) markes as MISSING, save the workbook and try again.

 

[bamaisgreat]

Yep, that would definitely cause that error message.

You didn't answer the question I asked about if the two computer are using the same version of Excel or not. Sometimes, if you create some VBA code or a newer version and try to run it on an older version, it won't work because you may be using newer features that weren't available in the lower versions. If creating Excel files for multiple users, I always recommend writing it on the oldest version of Excel that any of your users will be using.

In any event, here are some articles that may have you resolve your missing library:
MISSING: Microsoft Windows Common Controls-2 6.0
Missing References In VBA

Sorry about that It was made in Excel 2007 and both computers are 2007