Archive of Mr Excel Message Board

Back to Excel VBA archive index
Back to archive home

Excel 4 macro

Posted by Pat Shah on January 26, 2002 10:45 PM

Hi, I'd appreciate it if someone could tell me how to convert a macro originally written in excel 4 to excel 2002.

Basically, the macro uses keystrokes to iterate through different number formats, fonts, etc. It's extremely useful when modeling. I'd love to have it back!

Thanks, Pat

Check out our Excel VBA Resources

Re : Excel 4 macro

Posted by Falstaff on January 26, 2002 11:22 PM

Bad news : you have to re-write it in VBA (no quick way).

Good news : you should still be able to use the XLM without re-writing it in VBA

Re: Re : Excel 4 macro

Posted by Pat Shah on January 29, 2002 11:37 PM

I'm pretty experienced with most of Excel's command, but never did learn VBA. I've always recorded macros by hitting 'record' and going through the steps.

Can you tell specfically how to convert this file using XLM. If it's too difficult for a 'beginner', than is their someone you can recommend to do it for me.

Thanks,

Pat

Re: Re : Excel 4 macro

Posted by Hotspur on January 30, 2002 1:56 AM

You have to know VBA to convert your XLM.
But .... you can run your XLM in Excel 2002.
Just open the file containing the macro and run it.

Re: Re : Excel 4 macro

Posted by pat shah on January 30, 2002 2:52 PM

Thanks for the response. I seem to be getting errors when I try to iterate to a different format. The dialog box says their is an error in the macro, and presents some options to solve them which requires VBA skills, I imagine.

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.