Strange Compile Error...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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

Q - Open Specific Sheet 3
Compile error in hidden module: USAs 2
Compile error [Chr(13)] 3
excel macro in '97 does not work in Vista 2
compile error HELP ! 3
Compilation error in hidden module 4
Compile Error: with VBA call to "Format" 9
Application.VBE.CommandBars -- Compile error 2

Back
Top