Copy sheet that consist of macro

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).

Hi @TyraS

Use Copy/Paste Range activity or Duplicate Sheet activity

I hope it helps!!


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