Upgrade Old Excel Macros?

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!

In article <2c62401c4694c$2e9a4670$a401280a@phx.gbl>,
"Mark Pruden" <pruden.RemoveThis@fuse.net> wrote:

 > 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:

<a style='text-decoration: underline;' href="http://www.mvps.org/dmcritchie/excel/getstarted.htm" target="_blank">http://www.mvps.org/dmcritchie/excel/getstarted.htm</a>

Be sure to post back here when you have questions.<!-- ~MESSAGE_AFTER~ -->