Compile error

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

Guest

Hi all,
I emailed myself a file home that I had been working on at work writing VBA.
Upon trying to open the file at home, it auto-opens the VBA editor and up
pops an error that reads
Compile error:
Can't find project or Library

I'm running excel 2002 both at work and at home. this file runs perfectly at
work. Any ideas how to fin this problem???
 
I suspect your code refers to another library or you do not have VBA fully
loaded on the other machine. Try loading Office again and select full from
the options. If this fails, open the code and see if it refers to another
object library, say Word, PowerPoint, etc and then go to
Tools>References... and add that library

You may be able to run the code and when it errors look for a (missing) flag
next to the libraries in the list

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
web: www.nickhodge.co.uk
blog (non-tech): www.nickhodge.co.uk/blog/
 
Back
Top