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

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

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.



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.

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.