How to Compare Workbook VBA modules

  • Thread starter Thread starter Dan
  • Start date Start date
I am looking for tools that can help me compare the differences in the
VBA code between two versions of a Workbook.

In a previous posting to this group:

http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&[email protected]

Bill Manville provided some code to compare the contents of VBA
modules in two workbooks.

Has anyone done any further development on this or know of any other
tools to do the job.
Click to expand...

I would export the modules to a file and use WinDiff, FC, or any other of
such compare tools. I suspect you could even use MS Word for that.
 
Michael,

Thanks for the suggestion but it is a bit of a labourious process when
you've several workbooks to manage, each with several modules and need
to do these comparisons often.

I will post the results of my endevours if I get around to doing any
further development in this area.

By the way I asked the makers of "Excel Compare", www.formulasoft.com,
about this feature and they said that they planned to add it to a
further release of their tool.

Dan
 
Back
Top