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.
--
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?

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" <(E-Mail Removed)> wrote in message
news:2EE8FFDA-D145-44FB-AA30-(E-Mail Removed)...
> 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?

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

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


"Cheer-Phil-ly"
<(E-Mail Removed)>
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?