Any way to compare VBA code in different workbooks?
 

I have a Work-in-Process workbook and a Production workbook that many people
use daily. Sometimes I can grab the Production workbook and make VBA changes
but other times I have to make changes in the WIP version. Is there any way
to compare VBA code in two different workbooks?

Any way to compare VBA code in different workbooks?
 

Export the modules from each workbook and then rename the files from .bas to
..txt

Then import the .txt files into separate columns in a worksheet and do a
column comparison.
--
Gary's Student


"Cheer-Phil-ly" wrote:

I have a Work-in-Process workbook and a Production workbook that many people
use daily. Sometimes I can grab the Production workbook and make VBA changes
but other times I have to make changes in the WIP version. Is there any way
to compare VBA code in two different workbooks?

Any way to compare VBA code in different workbooks?
 

Or use a text editor that compares, as they are only text files.

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Gary''s Student" wrote in message
...
Export the modules from each workbook and then rename the files from .bas
to
.txt

Then import the .txt files into separate columns in a worksheet and do a
column comparison.
--
Gary's Student


"Cheer-Phil-ly" wrote:

I have a Work-in-Process workbook and a Production workbook that many
people
use daily. Sometimes I can grab the Production workbook and make VBA
changes
but other times I have to make changes in the WIP version. Is there any
way
to compare VBA code in two different workbooks?

Any way to compare VBA code in different workbooks?
 

MSWord has a comparison utility (Tools|Compare and Merge documents).

But you'll have to put the code into .txt files (or .doc files).

Cheer-Phil-ly wrote:

I have a Work-in-Process workbook and a Production workbook that many people
use daily. Sometimes I can grab the Production workbook and make VBA changes
but other times I have to make changes in the WIP version. Is there any way
to compare VBA code in two different workbooks?

--

Dave Peterson

Any way to compare VBA code in different workbooks?
 

Or maybe just use the latest version in both workbooks ?
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"Cheer-Phil-ly"

wrote in message
I have a Work-in-Process workbook and a Production workbook that many people
use daily. Sometimes I can grab the Production workbook and make VBA changes
but other times I have to make changes in the WIP version. Is there any way
to compare VBA code in two different workbooks?