How to merge two excel files?

[maheshmaxi]

Hi,

I have two excel files contains same kind of sheets in the same order, even all those sheets of two files contain same format of data. I would like to merge both as one sheet without doing copy and paste work, since i have more than 15 sheets in those files. Can anyone help me on this?

 

[VoG]

This should help you http://msdn.microsoft.com/en-us/library/cc837974.aspx