how to combine 2 or excel into 1 excel file(different sheet)

[althonfx]

hi, i am newbie in excel programming...


can anyone tell me how to combine 2 or excel into 1 excel file(different sheet)?

example:

i wan combine excel file A and excel file B into excel file C (in differrent sheet), using marcos.


how should i do??

[Mike Fogleman]

Just a guess, but this will copy sheet1 to sheet3 and copy sheet2 to the
next available row in sheet3:

Sub CopySheets()
Dim iLRow As Long
Sheets("Sheet1").UsedRange.Copy Destination:= _
Sheets("Sheet3").Range("A1")
iLRow = Sheets("Sheet3").Cells(Rows.Count, "A").End(xlUp).Row
Sheets("Sheet2").UsedRange.Copy Destination:= _
Sheets("Sheet3").Range("A" & iLRow + 1)
End Sub

Mike F
"althonfx" <althonfx.1xtbqd_1130839540.328@excelforum-nospam.com> wrote in
message news:althonfx.1xtbqd_1130839540.328@excelforum-nospam.com...
>
> hi, i am newbie in excel programming...
>
>
> can anyone tell me how to combine 2 or excel into 1 excel
> file(different sheet)?
>
> example:
>
> i wan combine excel file A and excel file B into excel file C (in
> differrent sheet), using marcos.
>
>
> how should i do??
>
>
> --
> althonfx
> ------------------------------------------------------------------------
> althonfx's Profile:
> http://www.excelforum.com/member.php...o&userid=28473
> View this thread: http://www.excelforum.com/showthread...hreadid=480787
>