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

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

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!)



Dave wrote:

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

--

Dave Peterson

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.

On Tue, 16 Nov 2004 20:17:39 -0600, Dave Peterson
wrote:

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!)



Dave wrote:

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

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