Excel 2002 VBA App fails in Excel 2000 Environment

[Steve Bunker]

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.

 

[Bernie Deitrick]

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

 

[Tom Ogilvy]

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.