Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
VBA Dialog to Select a Macro
Message
Information générale
Forum:
Microsoft Office
Catégorie:
Word
Divers
Thread ID:
00590775
Message ID:
00591912
Vues:
24
>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

Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform