How to copy 10,000 excel rows into another excel file sheet

Help Studio
, ,
1

Hi All,

I have Two excel files
A.xls
B.xlsm - it’s macro enabled file

In A.xls Sheet1 is present, i want to copy this Sheet1 and paste it into B.xlsm under Test Sheet. Then in B.xlsm go to button sheet and click on on that button. Then one report will execute then i want to save this report in folder and close A.xls and B.xlsm without saving.

Here is my flow

Excel Process Scope
Use Excel file - A.xls
Use Excel file - B.xlsm
Copy/Paste Range
Source from Sheet1 in A.xls into destination for Test Sheet in B.xlsm
Execute macro
For Go to Button Sheet and click on button
Assign Activity - folder path to save report
Save Excel File As.

In B.xlsm I add VBA code for Go to Button Sheet and click on button, button is showing macro button.

In VBA code, it is go to Button sheet and click on Macro button. Then I’m using this in UiPath Execute Macro activity.

Now issue is it’s showing only loading excel and got Runtime execution error in Execute Macro activity.
The remote procedure called failed (0×800706BE)

Many Thanks for help

2

Try adding Delay before Execute Macro
Sometimes Excel is still processing when UiPath tries to run the macro.
Insert a Delay of 3-5 seconds just before the Execute Macro activity.