Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    199
    Thanks
    8
    Thanked 0 Times in 0 Posts

    Listing of Macros (W2K)

    Hi,

    I need to get a list in a Word document of the names of all my macros in any particular template. Can one of you Word and VBA Experts please help me out. I know I can get a full listing of any or all macros from the VB Editor, but is there an easy way to list the macros by name.

    Thanks in advance,

    Peter Moran
    Two heads are always better than one!!

  2. #2
    Lounger
    Join Date
    Dec 2002
    Location
    Hull, Yorkshire, England
    Posts
    27
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Listing of Macros (W2K)

    Hi Peter,

    Check out the MS KB article 262961 "WD2000: Sample Macro to Return Macro and Procedure Names" to see if this helps.

    Cheers.

    Ed

    Edited: <!t><!/t> and <!t>.<!/t> tags added around the article title to make the link live. -Mod.

  3. #3
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    199
    Thanks
    8
    Thanked 0 Times in 0 Posts

    Re: Listing of Macros (W2K)

    Hi Ed,

    Thanks for the URL. I had tried a search on Microsoft, but obviously did not search on the correct words.

    Actually I have tried the macro, but the results are not quite what I expected. It certainly did not list all the macros in my normal.dot, so I shall do some further investigating.

    Once again thanks for the help.

    Regards,

    Peter Moran
    Two heads are always better than one!!

  4. #4
    5 Star Lounger
    Join Date
    Jul 2002
    Location
    Toronto, Ontario, Canada
    Posts
    1,139
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Listing of Macros (W2K)

    Peter,

    I have written a COM Add-In (and application specific templates) that will list all the open VBA Projects, all the components in those projects, all the procedures in those components and all the declaration lines of the declared Variables in those procedures. It presents it in a treeview listing that can be exported to a Word Doc or Excel spreadsheet.

    It may give you what you need.

    You can get it from http://www3.sympatico.ca/carbonnb/bryan/xa...istvbavars.html
    --
    Bryan Carbonnell - Toronto <img src=/S/flags/Ontario.gif border=0 alt=Ontario width=30 height=18> <img src=/S/flags/Canada.gif border=0 alt=Canada width=30 height=18>
    Unfortunately common sense isn't so common!!
    Visit my website for useful Word, Excel and Access code, templates and Add-Ins

Posting Permissions

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