Convert Macro to VBA

[Aussiebear]

I notice that in Access you can use an option to convert your macro's to VBA, is this possible in Excel? And just to cloud the issue a little further, I was under the impression that macros were already in VBA, just that its format was more rigid rather than the flowing structure that you see with most programer"s code.

[TrippyTom]

Hmm.... we don't have Access at work, but in Excel, macros are VBA already, as you thought. You can usually reduce the extraneous lines of code however if you used the macro recorder feature. It records ALL possible parameters (that you don't necessarily need) when you record things.

Also, you can't accomplish everything in the macro recorder. VBA allows you more freedom to do what you want.

[mdmackillop]

Hi Aussiebear,
I think that the Excel equivalent to Access Macros was the Module sheet, used with Excel 95 if I remember correctly. These can be converted to VBA, but its not an issue with the coding we're doing here, which as you say is done directly in VBA
Regards
MD