Microsoft Excel/ Basic - macros

  eivets 13:35 26 Mar 04
Locked

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!

Cheers

  Megatyte 13:53 26 Mar 04

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

AH

  VoG II 16:22 26 Mar 04

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 04

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 04

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.

Surface Pro (2017) vs Surface Pro 4

Where HTML5 is headed next

MacBook Pro v Surface Pro 5