Thread: Compiler Error
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Compiler Error

With that project active, click on Tools|References.

Look for a reference marked MISSING. You'll have to decide if you need to
replace it or just uncheck it.

The line marked in error may not (will probably not!) have anything to do with
the missing reference.

Bobzter100 wrote:

Hi
I made some macros that enable me to rename a tab (excel) depending what
date and time it is. I then run another to save the file by the tab name -
all works great on the computer i wrote the file on.
When i transfer the file to a friends computer i get the the visual basic
error..."Compiler Error Can't find project or library".
I did amend the original macro by formatting the date and time in the
form... format(date,"dd,mm,yy") and format(time,"hh,mm") and it is at these
two statemants that I receive the error. We both run excel 2002 sp2 and the
same error comes up on another computer that's running excel 2003 sp2.
Any help?
Bobzter


--

Dave Peterson