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.

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.

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.