Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VBA Dialog to Select a Macro
Message
General information
Forum:
Microsoft Office
Category:
Word
Miscellaneous
Thread ID:
00590775
Message ID:
00591912
Views:
23
>Hi,
>
>I need to create a dialog that replaces the Tools->Macros dialog. I need to get the list of macros in a template (typically, Normal.Dot) adds descriptions to them and displays the macros in a list box from which users may select a macro to run.
>
>1. Does something like this exist?
>2. If not, How do I get that list of macros?
>
>Thanks for all your help...
>
>Menachem Bazian

I believe you are going to have to roll your own. I would imagine that if you didn't need a full scale dynamic app, you could just build a little proggie and stuff it in its own table or spreadsheet. (You can access data from a sheet without opening it.)
If you need it to be dynamic well then you might be able to pull those macros out of the object model. I can't check right now as I dont have MSDN installed on this box. I would start looking off of the Application. tree. You should look into creating addins references in order to see how to get the available macros. Hopefully none of this is too far off base.
~Joe Johnston USA

"If ye love wealth better than liberty, the tranquility of servitude better than the animated contest of freedom, go home from us in peace. We ask not your counsel or arms. Crouch down and lick the hands which feed you. May your chains set lightly upon you, and may posterity forget that ye were our countrymen."
~Samuel Adams

Previous
Reply
Map
View

Click here to load this message in the networking platform