Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compile error when opend from other PC
I have quite a complex VB Excel file with many macros and Forms.
All works great on my PC, but when the file is opened from another users PC it immediately comes up with a Copile error. Cannot find Library etc. The VB line highlighed is : Sheet1.Range("C16").Value = Format(Now, "mmmm yy") With the [Format] Highlighted. If i click OK, and try to run a macro i then get another Compile error. Is there a way to fix this? Both PC's re running Office XP and have ALL Excel components installed. Corey.... |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compile error when opend from other PC
You have a library referenced on your PC that is not available on the other
PC, you may not even be using anything from this library but it will create this error. Reset yout VBA project and then go to TOOLS - REFERENCES and the unavailable libraries will have something in braces after it, I can't remeber exactly what but it will be obvious when you see it, uncheck the library on the users pc and all should be well. You should then uncheck these on your PC and re save the file. This should prevent this happening on other machines. hth Mark "Corey" wrote: I have quite a complex VB Excel file with many macros and Forms. All works great on my PC, but when the file is opened from another users PC it immediately comes up with a Copile error. Cannot find Library etc. The VB line highlighed is : Sheet1.Range("C16").Value = Format(Now, "mmmm yy") With the [Format] Highlighted. If i click OK, and try to run a macro i then get another Compile error. Is there a way to fix this? Both PC's re running Office XP and have ALL Excel components installed. Corey.... |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compile error when opend from other PC
I've just remembered it says (MISSING) in the braces, funny that isn't it.
"Corey" wrote: I have quite a complex VB Excel file with many macros and Forms. All works great on my PC, but when the file is opened from another users PC it immediately comes up with a Copile error. Cannot find Library etc. The VB line highlighed is : Sheet1.Range("C16").Value = Format(Now, "mmmm yy") With the [Format] Highlighted. If i click OK, and try to run a macro i then get another Compile error. Is there a way to fix this? Both PC's re running Office XP and have ALL Excel components installed. Corey.... |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compile error when opend from other PC
Thanks mark.
Done the trick. "Mark Dullingham" wrote in message ... I've just remembered it says (MISSING) in the braces, funny that isn't it. "Corey" wrote: I have quite a complex VB Excel file with many macros and Forms. All works great on my PC, but when the file is opened from another users PC it immediately comes up with a Copile error. Cannot find Library etc. The VB line highlighed is : Sheet1.Range("C16").Value = Format(Now, "mmmm yy") With the [Format] Highlighted. If i click OK, and try to run a macro i then get another Compile error. Is there a way to fix this? Both PC's re running Office XP and have ALL Excel components installed. Corey.... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBAProject name compile error, not defined at compile time | Excel Programming | |||
Excel 2003 file opend in Excel 2000 - Compile error in hidden modu | Excel Programming | |||
error message: compile error, argument not optional | Excel Programming | |||
How do I get rid of "Compile error in hidden module" error message | Excel Discussion (Misc queries) |