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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2002 VBA App fails in Excel 2000 Environment
Steve,
Have you tried running a copy of the original (six months ago) version on the client's machine? If it doesn't work then something external to your app has changed: if it works, then it may be the working copy of the app is bad. Also, have you tried Rob Bovey's code cleaner: http://www.appspro.com/downloads/CodeCleaner.exe HTH, Bernie Excel MVP "Steve Bunker" wrote in message ... 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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2002 VBA App fails in Excel 2000 Environment
What changed at the client site? What did they do just before the workbook
began to fail? One possibility is there is a bad reference in the file In the VBE, go to Tools=References (with this workbook as the active project) and see if there is a reference shown as MISSING. It is possible an upgrade or security fix changed the location of a DLL or something. -- Regards, Tom Ogilvy "Steve Bunker" wrote in message ... 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. |
Reply |
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) |