Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem with VBA code written in Excel 2002 working in Office 2003
Okay, I know its a wordy title but it describes my problem in general.
I have some code written in Office XP that will work on my computer, and at least one other computer which has Office 2003 with no issues. When I tried to use it on a third computer, which has Office 2003 installed on it, I kept getting compile errors. I would have a compile error saying that it could not find the specified project or module when dealing with a Right or Left vba function. It would also have errors relating to an undeclared "i" or "j" for a For-Next function. While I know it is not good ettiquette to have an undeclared variable, it still worked on two out of three computers. Does anyone know what could be causing this? Thanks Dave |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem with VBA code written in Excel 2002 working in Office 2003
As a first guess I would look for a missing Reference. On the computer that
is causing the error, in the VBE select Tools - References and then look for a checked item that starts with Missing... -- HTH... Jim Thomlinson " wrote: Okay, I know its a wordy title but it describes my problem in general. I have some code written in Office XP that will work on my computer, and at least one other computer which has Office 2003 with no issues. When I tried to use it on a third computer, which has Office 2003 installed on it, I kept getting compile errors. I would have a compile error saying that it could not find the specified project or module when dealing with a Right or Left vba function. It would also have errors relating to an undeclared "i" or "j" for a For-Next function. While I know it is not good ettiquette to have an undeclared variable, it still worked on two out of three computers. Does anyone know what could be causing this? Thanks Dave |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem with VBA code written in Excel 2002 working in Office 2003
Hi Dave
Look for missing references in the VBA editor ToolsReferences And look in ToolsOptions Editor ( variable declaration) General (error trapping) -- Regards Ron de Bruin http://www.rondebruin.nl wrote in message ups.com... Okay, I know its a wordy title but it describes my problem in general. I have some code written in Office XP that will work on my computer, and at least one other computer which has Office 2003 with no issues. When I tried to use it on a third computer, which has Office 2003 installed on it, I kept getting compile errors. I would have a compile error saying that it could not find the specified project or module when dealing with a Right or Left vba function. It would also have errors relating to an undeclared "i" or "j" for a For-Next function. While I know it is not good ettiquette to have an undeclared variable, it still worked on two out of three computers. Does anyone know what could be causing this? Thanks Dave |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Office 2007 compatibility at office 2003 is not working for graphs | Excel Discussion (Misc queries) | |||
Compiling Excel 2003 application written in VBA 6.0 Code | Excel Programming | |||
Excel SendMail Not working in XP Office 2003 | Excel Programming | |||
Excel 2002, VC++ problem, CreateDispatch not working | Excel Programming | |||
macro written in Excel 2000 not working in Excel 2002 | Excel Programming |