Microsoft Excel/ Basic - macros

  eivets 13:35 26 Mar 2004

I am trying to run a macro that works on other machines but when i try to run it, a microsoft visual basic compile error comes up saying cant find project or library...can anyone help?

Ps i a excel novice so please keep it simple!


  Megatyte 13:53 26 Mar 2004

Which version of Excel was it written in, and which version are you using?


  VoG II 16:22 26 Mar 2004

What is the VBA error number. Please post the exact error. Also do you get a Debug option? If so use it and post the line of code that is highlighted in the debugger.

  eivets 09:35 29 Mar 2004

error is...."Compile error: cant find project or library"

Line highlighted is Sub GetBom()

Another problem ive got is someone has password protected a excel file, i need the formulas but i can not contact the person who made it up to get the password, is there any way of unlocking this or copying it into another file somehow???

Cheers for any help!

  VoG II 12:54 29 Mar 2004

If Sub GetBom() is not included in the file that is why it will be coming up with an error. Maybe that macro is included in a file in the XLStart folder on the machine that it works on?

It would help if you could answer Megatyte's question.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Xiaomi Mi Mix 2 review

What went wrong at the Designs of the Year 2017

iPhone X news: Release date, price, new features & specs

Comment créer, modifier et réinitialiser un compte Apple ?