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.