Any way to compare VBA code in different workbooks?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.
 
Or use a text editor that compares, as they are only text files.

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)
 
MSWord has a comparison utility (Tools|Compare and Merge documents).

But you'll have to put the code into .txt files (or .doc files).
 
Or maybe just use the latest version in both workbooks ?
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"Cheer-Phil-ly"
<[email protected]>
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?
 
Back
Top