If you know that the code in WB1 changed and you want to change the code in
WB2 only if WB1 changed, then you don't need to check the code of WB2. I
presume you might have multiple workbooks you are looking to change. You
could set up code that will loop through each individual workbook and make
the change.

Let me know if I'm thinking about this the wrong way.


--
JNW


"Nayan" wrote:

Hello,

(Environment Excel 2003)

I have a parent workbook (Say WB1.XLS) which contains code behind in its
sheet1.
I made a copy of WB1 say WB2.XLS.

Now the code behind in sheet1 in WB1 changed.

I need a programm that can compare the code between WB1.sheet1 and WB2.sheet1.

if vba code is different then
copy the code from WB1.Sheet1 to WB2.sheet1

At run time I can export/Import the modules (.BAS, .FRM, .CLS) . I tried
exporting sheets but they are stored as .CLS extentions and when I import
these sheets they come back as class modules (.CLS) 'not useful'.

With code I can get the count of lines of code for each sheet (which I can
use to compare ) but how to get the code itself from the sheet and once i get
the code how to insert that code in another sheet to overwrite ?

Any suggestions or ideas.

Thanks in advance

Nayan