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 creating 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.