Macro Definition (VBA/Word/2000 & 2003)

Topic

New Reply

On reviewing Operating parameter limitations and specifications in Word, I see that there is a limitation of 150 macros. Since the MSDN Library defines a macro as [indent]

---

An action or a set of actions you can use to automate tasks.

---

[/indent]I am left confused. Are we limited to 150:

• Modules?
• Procedures?
• Entry points visible from Word through Alt + F8?
• Some other factor?
  [/list] Any clarification would be appreciated.

Reply | Quote

Replies

Frankly, I think the info is out-of-date. I can add 200 macros to a single module without problems, and 200 modules to a template without problems too.

Are you afraid you’re nearing a limit?

Reply | Quote

No Hans, just mystified by a spec that doesn’t seem quite logical.

Thanks for your guidance.

Reply | Quote

Just for “fun”, as experiment, ran the attached procedure in VB Editor, with Normal.dot as the active VBA project:

InsertMacros 20, 1000

This resulted in creation of 20 new code modules, each with 1000 public sub procedures, for a total of 20,000 “macros” available from the Normal.dot template. Was able to save changes (resulting in a slow-loading Normal.dot file almost 6 MB in size). Resulting macros ran successfully from the Word user interface (the macro list took a while to load). So it does appear as noted by Hans, the MSKB article is apparently outdated.

NOTE: This was tested with a COPY of actual Normal template. Do not recommend add 20,000 macros to your actual Normal.dot template. Tested on system with Word 2000.

HTH

Reply | Quote

I wonder if that referes to Word Basic macros (the predecessor to VBA).

Reply | Quote