Copy sheet that consist of macro

[TyraS (Tyra)]

any way to copy/duplicate a sheetin the same excel file?
the sheet contains macro, so the new copied sheet should have its own macro too.
tried copy sheet activity and got the following error:
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).

[lrtetala (Lakshman Reddy)]

Hi @TyraS

Use Copy/Paste Range activity or Duplicate Sheet activity

I hope it helps!!

[lrtetala (Lakshman Reddy)]

@TyraS

The Excel Copy Sheet activity does not function properly with Office 2010 and 2013 versions.

Copy Sheet activity throwing exception

I have hard time reproducing it to fail, but I also found out that it might be related to the Copy Sheet activity. Do you happen to use Office 2010 or 2013? If you go to the documentation of this activity, there is a known bug related to it: [image]