Analysing Excel VBA/Macro code

Is there a tool which will analyse/parse an entire Excel workbook and let us see all the macros, functions, VBA code?

I've been given a large number of Excel spreadsheets to analyse, we need to know what they do and how they do it, with a view to cr开发者_Python百科eating documentation, and/or re-writing. In many instances the original developers are gone and the users don't know the detail.

---

You can use MZ Tools which can give you some documentation generation abilities.

There's also some examples of how to do this yourself with VBA here

---

Additional resources for this question.

For office 2010 you can now use a VBA inspection tool that will alert you to upgrading issues such as deprecated Object model calls, Win32 calls, ActiveX controls that may/will require code changes. Doesn't provide a complete output of all method and class names. So its not useful for commenting your entire code base, but it does provide useful upgrading comments.

Remediation Guide

Code compatibility Guide