vba in excel 2000 v 1997

  • Thread starter Thread starter scottwilsonx
  • Start date Start date
S

scottwilsonx

Can anyone help?

I have developed an Excel worjksheet running a number of macros an
functions using VBA. This was complied in Excel 2000 for XP, but whe
users using Excel 97 on NT try to open the file it crashes. I thin
this is something to do with the VB.

Does anyone know how to stop this happening ? I have tried saving m
file as Excel 97 but it still happens!

All advice gratefully received. Does anyone know about a converto
that maybe available?

Thanks
Scott
 
Have you tried commenting out all the routines bar one and then opening the
workbook in 97, running through them all to find which ones are killing it. If
you can do that and find the bad ones then post the code here, you will likely
get a solution.

If you have lots of modules then with a copy of the workbook try deleting all
modules except one and it may help you track down the module containing the
rogue code.

Just as an aside, if you are going to develop apps for more than one version of
Excel, you really need to develop in the lowest one that will be used else you
will often hit problems like this.
 
Does crash mean that the workbook opens, but a macro abnormally ends?

Or does it mean that excel comes crashing down?

There are diffences in code that would cause macros to burp (but not crash
excel).
 
Back
Top