Strange Compile Error...

I

IT_roofer

I'm working on a complex UserForm that fetches data from an mdb file and I
went to test it on my bosses (!) machine and Excel gave this error: "Compile
error in hidden (something) ThisWorkBook" - So I go into the VB Editor and
rerun the module "WorkBook_Open()" and Excel is complaining about the Chr()
function... only this time it says "Compiler error: can not find project or
library" - So I'm thinking it's a reference library issue, but why would it
get hung up on the Chr() function? ... thanks for any help!
 
J

Jim Thomlinson

Your issue has nothing to do with the Chr function. Your first instinct was
correct in that it is probably a missing reference. In the VBE open Tools ->
References and look for an item marked "Missing:". Probably Microsoft ActiveX
Data Objects 2.x (guessing but 2.8 is my guess). You can either change your
code to late binding or you can change the reference to a earlier version
like Microsoft ActiveX Data Objects 2.5...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Compile Error: with VBA call to "Format" 9
Application.VBE.CommandBars -- Compile error 2
Calendar code error. 7
Error: "Compile error in hidden module: Main" 1
excel macro in '97 does not work in Vista 2
Compile error in hidden module: USAs 2
Compile error in hidden module:frmwork 3
SOLVER COMPILE ERROR: "CAN'T FIND PROJECT OR LIBRARY" 2003 VS 2007 1

Top