Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Compare workbooks | Excel Discussion (Misc queries) | |||
Compare workbooks | Excel Discussion (Misc queries) | |||
compare different workbooks | Excel Worksheet Functions | |||
Compare workbooks | Excel Programming | |||
COMPARE 2 WORKBOOKS | Excel Programming |