Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2002 VBA App fails in Excel 2000 Environment
Have developed fairly comprehensive (15 forms)stock
control system using Excel 2002/VBA under WinXP. Ran perfectly for 6 months at client site with Excel 2000 under Win2000. Suddenly gives error when loading: "Excel has encountered errors, is writing log, etc.". Works fine in original dev. environment. Checked with Excel 2002 under Win98: loads OK but basic VBA commands fail horibly; examples: simple VBA command to copy a sheet to a new sheet bombs but syntax perfect; several forms cannot be found, gives "path/file error" even though one of the forms is a 'flash screen' which appeared perfectly when launching app. Any ideas? I thought VBA was up/downward compatible from Excel 97 onwards. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
excel 2000 fails to open excel 2003 file | Excel Discussion (Misc queries) | |||
Activate method of Worksheet class fails in Excel 2000 | Excel Discussion (Misc queries) | |||
Can you use excel 2003 version with excel 2002 and 2000 on a netw. | Excel Discussion (Misc queries) | |||
How do I update Excel 2000 macros to work in Excel 2002? | Excel Discussion (Misc queries) |