Excel XP 2002 compatibility with older versions (macros)

  • Thread starter Thread starter jeff
  • Start date Start date
J

jeff

I have developed a spreadsheet that has macros in it. I
have sent it out to be used by others, but an error
message pops up when those with older versions of Excel
try to use the macro. Is there something I can do to
make this macro work for those with older versions of
Excel?
 
That depends entirely on exactly WHAT the error message is.

If you are using VBA functions that correspond to features not available in
the older version(s) of Excel, then you'll have to remove that code.
Potentially you can alter it to do it the "old" way so that it works, or you
can perform a test for the version in use and only execute the code if it's
appropriate.

Easiest solution is to develop in the oldest one that will be used; I keep
Excel 97 around and mainly use it for that reason.
--
HTH -

-Frank
Microsoft Excel MVP
Dolphin Technology Corp.
http://vbapro.com
 
Back
Top