Copy Sheet Error

Hi,

I am having the below error while trying to copy data from a sheet to another sheet within the same excel file.

Copy Sheet: Unable to cast COM object of type ‘System.__ComObject’ to interface type ‘Microsoft.Office.Interop.Excel._Workbook’. This operation failed because the QueryInterface call on the COM component for the interface with IID ‘{000208DA-0000-0000-C000-000000000046}’ failed due to the following error: The requested object does not exist. (Exception from HRESULT: 0x80010114).

I have tried putting the Delay Activity before it. It is the same issue. Also, note I am using Excel Version 2016.

hi @Bukola,

Which Excel version you are using ?

You can use CopyToWorkbook from below activity.


Mukesh

1 Like

Are you copying the whole sheet or only some column values? @Bukola

I am copying the whole sheet.

Any followup or solution on this? I am struggling with the exact same problem and have searched everywhere for a solution but I can not find anything that works.