How to Compare Workbook VBA modules
 

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=e...bbd0%40msn.com

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.

Thanks,

Dan

How to Compare Workbook VBA modules
 

On 14 Oct 2003 05:34:52 -0700, (Dan) wrote in
microsoft.public.excel.programming:

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=e...bbd0%40msn.com

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.

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 Bednarek
http://mcmbednarek.tripod.com/ "POST NO BILLS"

How to Compare Workbook VBA modules
 

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

Michael Bednarek wrote in message . ..
On 14 Oct 2003 05:34:52 -0700, (Dan) wrote in
microsoft.public.excel.programming:

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=e...bbd0%40msn.com

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.

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.