So I’ve been trying to copy a sheet from an excel to another, but with a different sheet name. Before the copy starts, Would Kill Application for Excel. Add an Excel Application Scope With Copy sheet activity inside of it. The Excel App Workbook path is file1, copy “Orders” sheet from it, then add to to excel file2 with sheetname “Failed Orders”. The file2 will always be new or created by excel application app.
Problem is, It keeps giving me either, 0x800706ba or 0x800a03ec error. I’ve tried using balareva’s “Create Workbook” , add delay, then “Copy To File” to copy the sheet. But the same error occurs on “Copy To File” activity.
This one works for tabled excels. Problem is, there I have many excel files that aren’t table where the datas needed are in an exact cell location. Some Sheets are also in pictures so read ranging does not work.
As suggested by @nikhil.girish ,you can use a Read Range Activity to copy the desired range, and then for the sheet name, you can pass that value into the Write Range Activity which will then create a new sheet with the desired name.
This is the file, I’m trying to read range all but they are formatted like this. The Receipt Tab is also needed if the order process did not fail, but that sheet only contains the picture of the recepit