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