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

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