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" wrote in message
...
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