Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2000 VBA Code not working in Excel 2002
Underlying VBA code will not compile due to Excel 2002's
failure to recognize a function/variable. This error occurs for any variables not explicitly declared at the beginning of a Sub/Function and for built in functions such as Str, Chr, and Format. This occurs even though Excel 2002 is configured to not require explicit typing of variables. The original workbook was created on a system running XP Pro 2002 SP-1 and Office 2000, 9.0.3821, SP-1 and runs fine on that machine. This issue occurs when the offending workbook is opened in Office 2002 SP-2 on a system running XP Pro. 2002 SP-1. Any advice/help is much appreciated. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2000 VBA Code not working in Excel 2002
OldGuy,
Most of the time when such built-in function do work, it is because the references have been unchecked or corrupted. Go to ToolsReferences and see if are marked "Missing". If so locate the correct libraries and save again. NickHK "OldGuy" wrote in message ... Underlying VBA code will not compile due to Excel 2002's failure to recognize a function/variable. This error occurs for any variables not explicitly declared at the beginning of a Sub/Function and for built in functions such as Str, Chr, and Format. This occurs even though Excel 2002 is configured to not require explicit typing of variables. The original workbook was created on a system running XP Pro 2002 SP-1 and Office 2000, 9.0.3821, SP-1 and runs fine on that machine. This issue occurs when the offending workbook is opened in Office 2002 SP-2 on a system running XP Pro. 2002 SP-1. Any advice/help is much appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can you use excel 2003 version with excel 2002 and 2000 on a netw. | Excel Discussion (Misc queries) | |||
Macro working in Excel 2003; not working in Excel 2000 | Excel Programming | |||
Code-signing certificate problems in Excel 2000 with Windows 2000 | Excel Programming | |||
Excel 2000 code not working in XP | Excel Programming | |||
macro written in Excel 2000 not working in Excel 2002 | Excel Programming |