Results 1 to 5 of 5
  1. #1
    Silver Lounger
    Join Date
    Jul 2001
    Location
    Ottawa, Ontario, Canada
    Posts
    1,609
    Thanks
    0
    Thanked 1 Time in 1 Post

    Macro Definition (VBA/Word/2000 & 2003)

    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
    <hr>An action or a set of actions you can use to automate tasks.<hr>
    I am left confused. Are we limited to 150:
    <UL><LI>Modules?
    <LI>Procedures?
    <LI>Entry points visible from Word through Alt + F8?
    <LI>Some other factor?[/list] Any clarification would be appreciated.
    Regards
    Don

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Macro Definition (VBA/Word/2000 & 2003)

    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?

  3. #3
    Silver Lounger
    Join Date
    Jul 2001
    Location
    Ottawa, Ontario, Canada
    Posts
    1,609
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Macro Definition (VBA/Word/2000 & 2003)

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

    Thanks for your guidance.
    Regards
    Don

  4. #4
    Bronze Lounger
    Join Date
    Nov 2001
    Location
    Arlington, Virginia, USA
    Posts
    1,394
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Re: Macro Definition (VBA/Word/2000 & 2003)

    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

  5. #5
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Macro Definition (VBA/Word/2000 & 2003)

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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •