Need to compare code in multiple modules to a master copy

[Dave]

Hello,

I've been given the task to automate vb code comparison from a new workbook
version to a "master copy."

For instance: Master Copy has 16 Modules in the vb project.

Someone makes changes to the code (in a different file) and asks that the
quality control guy accept it. Changes could have been made in any one or
all modules.

We need to see where the changes were made by comparing to the master copy.

If I can get all the modules from the master copy and then the new copy into
a Word document, I think we have a program that can highlight differences.

Any ideas/solutions appreciated.

Thanx

dave

 

[Bob Flanagan]

Dave, why not copy the code in the master from a module into a worksheet
starting in A1. And the new code for that module into C1. And in B1, put
the equation A1=C1 and copy down. When different, the values turn to false.

Robert Flanagan
Macro Systems
Delaware, U.S. 302-234-9857
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel

 

[Dave Peterson]

Another option would be to extract the modules to text files.

Then use MSWord's built in Tools|compare and merge documents.

(Depending on how big the modules are, it might work!)

 

[Myrna Larson]

Sounds like they need Version Control software. I don't know if there's
anything available that will work with VBA code without the need to export it
to text files, though.

 

[Dave]

That is basically what I want to do - copy all the modules into a
spreadsheet or Word document. Problem is how to copy all the modules
quickly. There are over 20 modules each containing multiple Functions and
Sub routines.

Can I write code to do this? The Quality Control guys just wants to hit a
button and have it all there for him.

thanx dave