Upgrade Old Excel Macros?

[Mark Pruden]

I'm a long-time Excel user, who created some macros many
upgrades ago (maybe 15 or so years ago) that have still
worked until now, including in Excel 2001 for Macintosh,
but some of them are not working in my new Excel 2004
upgrade. I'm assuming I originally created them in the
old XLM format, but I'm not even sure of that. I'm not
real sophisticated about these things. Is there any
relatively simple way to upgrade the old macros to the new
language (VBA I think), or do I have to put in many hours
recreating these in the new language?

Thanks much!

 

[JE McGimpsey]

I'm a long-time Excel user, who created some macros many
upgrades ago (maybe 15 or so years ago) that have still
worked until now, including in Excel 2001 for Macintosh,
but some of them are not working in my new Excel 2004
upgrade. I'm assuming I originally created them in the
old XLM format, but I'm not even sure of that. I'm not
real sophisticated about these things. Is there any
relatively simple way to upgrade the old macros to the new
language (VBA I think), or do I have to put in many hours
recreating these in the new language?

The good news is that most XL4M macros still work in XL04. I don't know
why some aren't, but you can still edit them in macro sheets.

There's no easy way to convert them. You can get a start on them by
recording a VBA macro while you perform the steps of the XL4 macro. The
VBA macro recorder is very rudimentary, however, and doesn't produce
anything like efficient code. But it generally works.

A good place to start with macros is David McRitchie's site:

http://www.mvps.org/dmcritchie/excel/getstarted.htm

Be sure to post back here when you have questions.

 

[Guest]

I'm new to newsgroups, and I don't know if communicating
appreciation is part of the protocol, I just wish to thank
you very much for the courtesy of you response, and the
valuable information in it. Thanks so much!

 

[Mark Pruden]

Whoops! I didn't mean for my appreciation to be anonymous!
I'm still learning this protocol! Thanks again.

 

[JE McGimpsey]

I'm new to newsgroups, and I don't know if communicating
appreciation is part of the protocol, I just wish to thank
you very much for the courtesy of you response, and the
valuable information in it. Thanks so much!

You're very welcome.