General information
Category:
COM/DCOM and OLE Automation
AFAIK, excel does not allow to move sheets between two instances of EXcel.
Try this instead:
oxlsSource = createobject('Excel.application')
oSourceWorkbook = oxlsSource.workbooks.open('e:\source.xls')
oTargetWorkbook = oxlsSource.workbooks.open('e:\target.xls')
oSourceWorkbook.worksheets(1).move(oTargetWorkbook.activesheet)
>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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only