Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 12
Default Compiler Error

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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Error: "Excel encountered an error and had to remove some formatti Carl Excel Discussion (Misc queries) 0 September 18th 06 06:39 PM
Counting instances of found text (Excel error? Or user error?) S Davis Excel Worksheet Functions 5 September 12th 06 04:52 PM
Excel Compiler Steve-in-austin Excel Discussion (Misc queries) 2 June 8th 06 06:44 PM
Excel 2003 Macro Error - Runtime error 1004 Cow Excel Discussion (Misc queries) 2 June 7th 05 01:40 PM


All times are GMT +1. The time now is 04:06 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"