Macros vs. VBA

[Don]

IS there a way to convert a Macro or many Macros into VBA
code? A Utility? A menu Option?

Thanks for any insight.

 

[mate]

yes, click to highlight the macro you want to convert than
go to "tools", than "Macros", and you will see an Option
that says, "convert macro to Visual Basic." When you
click in on modules, you will see the converted macro.

 

[John Vinson]

yes, click to highlight the macro you want to convert than
go to "tools", than "Macros", and you will see an Option
that says, "convert macro to Visual Basic." When you
click in on modules, you will see the converted macro.

Just note that the translation does work but it is VERY literal
minded: each macro step converts to a single VBA line. Very frequently
you can make marked improvements on the code by changing the logic to
use loops, arrays, IF - Then - Else code and the like.