Converting from Excel macros to VBA

[Doug Starkey]

is there a utility or reference guide available to help with converting
an old Excel 4.0-style macro into Excel VBA (Excel 2001)?

I am unable to get the ACTIVATE() function to work properly under Excel
2001 and need to update my macros to run under Excel 2001.

TIA,

Doug Starkey

 

[J.E. McGimpsey]

is there a utility or reference guide available to help with converting
an old Excel 4.0-style macro into Excel VBA (Excel 2001)?

I am unable to get the ACTIVATE() function to work properly under Excel
2001 and need to update my macros to run under Excel 2001.

AFAIK, there's really no utility or reference for conversion. The
easiest way I've found is to turn on the macro recorder and step
through the steps in the XL4 macro, then edit the result.

If you have specific questions, you might post them here (if they're
Mac specific) or in the microsoft.public.excel.programming newsgroup
(if general).