copy data from workbook to another workbook

[choppysuey]

hi all,

I was interested in knowing if any has an example of code of how to copy data from one excel workbook which contains multiple worksheets into a worksheet of another workbook.
(i.e. a worksheet named plant in myfile.xls to a worksheet named destination in otherfile.xls.)

I used the following code to open excel:

oExcel=CreateObject('Excel.Application')
oExcel.visible = .t.
oExcel.Workbooks.Open('C:\myfile.xls')

Now do i need to create another excel object to open otherfile.xls and then do the copy commands?

Thx in advance.

-suey