Excel Macro Language and Office 2004

[dalgleishj72]

I still have a lot of Macros in Microsoft Excel's old Macro language
and am about to migrate to Mac OSX. Part of this would be upgrading
from Office 2001 to Office 2004.

Will I be able to continue to run my old Macros?

If not is there a converter that effectively converts these to VBA
(something which despite the fact that I wrote two booklets many years
ago on the Macro language I have been unable to do on my own)

Thanks

 

[Fredrik Wahlgren]

I still have a lot of Macros in Microsoft Excel's old Macro language
and am about to migrate to Mac OSX. Part of this would be upgrading
from Office 2001 to Office 2004.

Will I be able to continue to run my old Macros?

If not is there a converter that effectively converts these to VBA
(something which despite the fact that I wrote two booklets many years
ago on the Macro language I have been unable to do on my own)

Thanks

I believe your macros will still run under Excel 2004. I am not aware of any
converter.

/ Fredrik

 

[JE McGimpsey]

I still have a lot of Macros in Microsoft Excel's old Macro language
and am about to migrate to Mac OSX. Part of this would be upgrading
from Office 2001 to Office 2004.

Will I be able to continue to run my old Macros?

If not is there a converter that effectively converts these to VBA
(something which despite the fact that I wrote two booklets many years
ago on the Macro language I have been unable to do on my own)

XL4 Macros will still work in XL04.

There's no converter. The best workaround is probably to record a VBA
macro that does the same thing. Note, however, that VBA's recorder is
not particularly efficient, and you need to be careful to specify
relative and absolute references (the default is absolute - use the
relative reference button on the macro recording toolbar to toggle
modes).

 

[dalgleishj72]

XL4 Macros will still work in XL04.

There's no converter. The best workaround is probably to record a VBA

macro that does the same thing. Note, however, that VBA's recorder is

not particularly efficient, and you need to be careful to specify
relative and absolute references (the default is absolute - use the
relative reference button on the macro recording toolbar to toggle
modes).

Many thanks, JE, for being definitive both as to the XL4Macros working
and as to the lack of a converter. I note your advice on creating a VBA
Macro but these XL4macros weren't created by the recorder and three
books later I'm unable to write a decent vba macro.

 

[JE McGimpsey]

Many thanks, JE, for being definitive both as to the XL4Macros working
and as to the lack of a converter. I note your advice on creating a VBA
Macro but these XL4macros weren't created by the recorder and three
books later I'm unable to write a decent vba macro.

If you can bite off small to medium chunks, post back here or in the
microsoft.public.excel.programming group. There's lots of help available.

One place you can start is David McRitchie's "Getting Started with
Macros" page:

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


The best book I've read, if you're at least reasonably familiar with XL
and programming, is John Walkenbach's "Excel 200x Power Programming with
VBA". For MacXL, you don't need the latest version - 2000 will do, and
95% of the book is applicable to Macs (about 90% of the 2003 version is
applicable).

 

[Fredrik Wahlgren]

Many thanks, JE, for being definitive both as to the XL4Macros working
and as to the lack of a converter. I note your advice on creating a VBA
Macro but these XL4macros weren't created by the recorder and three
books later I'm unable to write a decent vba macro.

If you want to make equivalent VBA code, you will need the documentation for
the old macro language. You can find it here:
http://support.microsoft.com/kb/q128185/

Youer macros may not be very hard to translate. Unless tehy are very
personal to you, you may want to submit a few to this newgroup and ask for
help.

Regards,
Fredrik

 

[Fredrik Wahlgren]

Many thanks, JE, for being definitive both as to the XL4Macros working
and as to the lack of a converter. I note your advice on creating a VBA
Macro but these XL4macros weren't created by the recorder and three
books later I'm unable to write a decent vba macro.

If you want to make equivalent VBA code, you will need the documentation for
the old macro language. You can find it here:
http://support.microsoft.com/kb/q128185/

Youer macros may not be very hard to translate. Unless tehy are very
personal to you, you may want to submit a few to this newgroup and ask for
help.

Regards,
Fredrik