macro issues with excel 97
 

I have several macros in an excel 2002 workbook that will not run in excel 97.
Is there a way to determin if it will ever run or what is causing the problem?

macro issues with excel 97
 

See which command chokes Excel 97, then check in the object browser or
online help for 97 what the syntax for 97 has to be. There were a bunch of
major changes to VBA between 97 and 2000, and 2002 added some further
changes.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"killian" wrote in message
...
I have several macros in an excel 2002 workbook that will not run in excel
97.
Is there a way to determin if it will ever run or what is causing the
problem?

macro issues with excel 97
 

There are a few new statements and methods in 2002 that were not in 97 but
generally macros should run.

IF we could see the code you would have a much better chance of getting more
help.

"will not run" doesn't give much to go on.


Gord Dibben MS Excel MVP

On Thu, 28 Feb 2008 14:08:00 -0800, killian
wrote:

I have several macros in an excel 2002 workbook that will not run in excel 97.
Is there a way to determin if it will ever run or what is causing the problem?