crash excel 97 in windows xp

[Rudolf Andringa]

When I try to open a certain .xls file, created in Excel XP, with a lot
of VBA macros in Excel 97, Excel 97 quits completely and even the Start
Menu of XP is affected, in casu blacked out. Sometimes Excel afterwards
does not even start up or is very slow and then hangs after a while.

Microsoft seems to have never heard of it, see the KB.

Has any one had the same expierience and does someone have a solution?

 

[Nick Hodge]

Rudolf

I would first check you are not using any features in your code that were
not in Excel 97 (Always an issue). Then I would run Rob Bovey's code
cleaner add-in over your code and see if it helps.

this can be found at www.bmsltd.ie or www.appspro.com

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)