How to copy huge excel data sheet into another excel file sheet

Help Studio
, ,
1

Hi,

I have two excel file
RowData.xls
Macro.xlsm

In RowData.xls only one sheet is present that is Sheet1.
I want to copy data inside Sheet1 and paste it into Macro.xlsm file under Data sheet.
Then in Macro.xlsm file go to Control sheet and in control sheet and there one button is present in Sheet. I want to Click on that button.
Then report will excute. I want to save this report in another folder and close Macro.xlsm file without saving.

Note- In RowData.xls, there are lot of data. There are more than 600 rows present in excel.

Below is my

  1. Read Range Workbook activity for reading row data Excel file.
  2. Excel Application Scope for Macro excel file
  3. Write range for write data into Macro file under Data sheet
  4. Execute Macro activity for Go to Control Sheet and click on button.
  5. Assign Activity for file path to save excute report in folder
  6. Excel process scope
  7. Use Excel file for Macro excel
  8. Save excel file As activity.
    Now I’m getting some excel pops like overflow and runtime error, method range object was failed.

Many thanks for help

2

Could you share the error screenshot

600 rows should be fine to handle. It shouldn’t be a problem

Kindly share your workflow image and the error which you are getting. Also on which activity you are getting the error