Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Error: "Excel encountered an error and had to remove some formatti | Excel Discussion (Misc queries) | |||
Counting instances of found text (Excel error? Or user error?) | Excel Worksheet Functions | |||
Excel Compiler | Excel Discussion (Misc queries) | |||
Excel 2003 Macro Error - Runtime error 1004 | Excel Discussion (Misc queries) |