I have only passing experience with Lotus, but by "macro menu" I
assume you mean a script that merely "clicks" various menu items.
Excel/VBA has no such capability. You can turn on the Macro Recorder
(on the Macros item on the Tools menu) and it will generate all the
VBA code that carries out the actions you perform. Macro recorder
generated code isn't very good on its own, but can provide a good
starting point and it does tell you which objects/properties/methods
are used in carrying out an action. It doesn't, though, use the actual
menu/commandbar selections.
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)
