I am trying to write sheet 1 of “+ courseCode +” + “-ExportedRoster.xls” (variable = ParentExportedRosterDT) into a new sheet named “+ courseCode +” + “-ExportedRoster” (in WorkbookPath “CompletionCreditBotNewTemplate.xlsm”).
I am receiving the error below – Write range : A strongly-named assembly is required. (Exception from HRESULT: 0x80131044)
How do I complete the fields so that Sheet 1 of “+ courseCode +” + “-ExportedRoster.xls” is pasted into a new sheet titled “+ courseCode +” + “-ExportedRoster.xls” in “CompletionCreditBotNewTemplate.xlsm”. Is creating a DT for the information in sheet 1 even necessary?
If you are creating .xls file then please use Write Range activity under Excel application scope of Excel instead of WorkBook as .xls file gets corrupted or gives error in Write Range of Workbook activity.