Hi,
I am trying to copy multiple excel worksheets into one target excel file.

All excel files have been created with a copy to xl5 statementand and thus have one worksheet named after the filename.

Here's what I've tried:

oxlsSource = createobject('Excel.application')
oxlsTarget = createobject('Excel.application')

oSourceWorkbook = oxlsSource.workbooks.open('e:\source.xls')
oTargetWorkbook = oxlsTarget.workbooks.open('e:\target.xls')
oSourceWorkbook.worksheets(1).move(oTargetWorkbook.activesheet)

When I do this, excel starts complaining about the properties of move that can't be fetched from the class worksheet.

What am I doing wrong?

TIA,
Raymond