crash excel 97 in windows xp

  • Thread starter Rudolf Andringa
  • 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?
 
N

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)
 
Q

Quaoar

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?

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top