CODEWITHSUNDEEP
excelvba
MrTelly
MrTelly

Reputation: 14875

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 creating documentation, and/or re-writing. In many instances the original developers are gone and the users don't know the detail.

Upvotes: 2

Views: 5308

Answers (2)

Anonymous Type
Anonymous Type

Reputation: 3061

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

Upvotes: 1

Jon Fournier
Jon Fournier

Reputation: 4327

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

Upvotes: 3

Related Questions