thank you for your replay.
This is good but it's a little different from what i want to do.
I have 2 workbook with 2 worksheets, (sheet1, sheet2)
All the tow workbook have exactly 2 worksheets with the same name: sheet1, sheet2
In the destination file i already have tow empty worksheets named: sheet1, sheet2
So what i need is to be in the destination workbook is this:
1: all data from the "first" worksheet from the 2 source workbook in the "sheet1" worksheet.
2: same for "sheet2" worksheet
this is link for the example file:
source-01, source-02, destination
about the link that you provided:
Range destRange = destSheet.Cells.CreateRange
(sourceRange.FirstRow + TotalRowCount, sourceRange.FirstColumn,
what i want to do is to copy "destRange" to a specific worksheet in the destination file.
I hope that now its more clear.
Thank you again