Marco from XP not working in 97

I wrote a bunch of Macros on my machine that runs Office XP, made them
into an Add-In and sent it out to everyone. Now the people that have
Excel 97 are getting errors and can't run the Marcos. It seems that I
used constants that aren't in VBA 5 (I think that is what Excel 97
uses) and therefore when the constant is undefined it error out. How
can I correct this? Define all the constants I used? Or is there a
way to find out which aren't available in 97 and somehow replace them?
Any ideas would be great.

-Steve

It is probably more than constants. It is probably arguments that aren't
available.

You would need to go to copy of excel 97 and run you macro, correcting the
errors as you encounter them. the usual advice is to always do your
development on the oldest version of Excel that will use the code.

--
Regards,
Tom Ogilvy

<brittonsm@verizon.net> wrote in message
news:1120159749.961232.149700@g44g2000cwa.googlegroups.com...
> I wrote a bunch of Macros on my machine that runs Office XP, made them
> into an Add-In and sent it out to everyone. Now the people that have
> Excel 97 are getting errors and can't run the Marcos. It seems that I
> used constants that aren't in VBA 5 (I think that is what Excel 97
> uses) and therefore when the constant is undefined it error out. How
> can I correct this? Define all the constants I used? Or is there a
> way to find out which aren't available in 97 and somehow replace them?
> Any ideas would be great.
>
> -Steve
>