Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Mar 2003
    Location
    Elkins Park, Pennsylvania, USA
    Posts
    325
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Determining Unused Modules and Procedures (Word XP/VBA)

    Hi. Can anyone recommend a good method or utility to use to clean out the VBA modules in my templates? I'm sure there are subs and functions that are no longer used or called by other procedures, and I'd like to get rid of those that aren't used. It seems a bit daunting to do an Edit Find for each procedure name, but I don't know any other way around it. I was hoping that there might be a good (hopefully free or cheap) utility that would help.
    <font face="Comic Sans MS">That's what you do in a herd; you look out for each other!</font face=comic> - Mike

  2. Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!

    Excel 2013: The Missing Manual

    + Get this BONUS — free!

    Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!

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

    Re: Determining Unused Modules and Procedures (Word XP/VBA)

    If you do a google search for vba "unused code" you'll find several utilies. Many of them are quite expensive, though.

    MZ-Tools is a VERY good utility, and it's <img src=/S/free.gif border=0 alt=free width=30 height=15>, but limited when it comes to detecting dead code:
    <hr>The add-in can review your source code at project-group, project or file level (through context menus) detecting unused variables, constants, parameters, private procedures, and so on. For performance reasons, only private declarations are reviewed.<hr>
    For VBA, you need MZ-Tools 3.0.

  4. #3
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Yilgarn region of Toronto, Ontario
    Posts
    5,453
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Determining Unused Modules and Procedures (Wor

    I have a developer tool "Procedure Stripper" that identifies & removes deadwood - procedures and data identifiers. It's not glossy, but I've been using it for about five years with no problems. Let me know if you'd like to try, and I'll put it on my downloads page. (It does other stuff, such as sorting procedures into sequence within each module).

  5. #4
    3 Star Lounger
    Join Date
    Mar 2003
    Location
    Elkins Park, Pennsylvania, USA
    Posts
    325
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Determining Unused Modules and Procedures (Wor

    That would be greatly appreciated. It sounds exactly like the sort of utility I'm looking for.
    Thanks.
    <font face="Comic Sans MS">That's what you do in a herd; you look out for each other!</font face=comic> - Mike

  6. #5
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Yilgarn region of Toronto, Ontario
    Posts
    5,453
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Determining Unused Modules and Procedures (Wor

    Try my particularly scary (right now) downloads page http://www.chrisgreaves.com/DownLoad.html and aim for Procs160.

Posting Permissions

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