crash excel 97 in windows xp

  • Thread starter Thread starter Rudolf Andringa
  • Start date Start date
R

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?
 
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)
 
Rudolf said:
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?
Click to expand...

If you use early binding of VBA objects when developing the code in
ExcelXP, the bindings might not be supported by the Excel97 object
libraries. The reverse, early binding in Excel97 is not a [as much of
a?]problem, since the later versions of object libraries tend to support
the more restricted Excel97 libraries. Many VBA programmers as a result
use Excel97 as the development base if they are after global
compatibility.

You can open the file in fom the Excel97 File/Open dialog with the shift
key held down when clicking the Open button to prevent macros running.
Then compile the code in the Excel97 VBEditor and see what errors pop
up.

Q
 
Back
Top