Skip to main content

Hi,

 

I’m trying to copy paste data from one excel to another excel using macro. What session name should be provided in the run macro action for the session name. I have more than 50 lakhs of data which is making normal copy paste method slow. hence doing it through macro. Its working manually when I run the macro but not working when I’m running in AA.

 

Can someone help asap?

 

Thanks!!

​@abhijna.nayak 

<rant>

I’m starting this reply with my standard warning: Excel is not a database. If you have 50 lakh (5 million) rows of data, you’re using the wrong tool for the job. You should be using a SQL database.

</rant>

Ahem.  😁

You can execute macros from within Automation Anywhere, but each spreadsheet you have open will have its own session name. Data will not be carried over from one session to the next.

That being said, if your macro is copying the data from one spreadsheet, then you execute the other macro to paste, it should be fine because you’re using Windows’ clipboard. That has nothing to do with AA other than executing the macro in an automated way.

Another possibility is to Excel advanced: Get worksheet as data table. This is essentially the same as a copy (also consuming a large amount of RAM) which you can then use an Excel advanced: Write from data table as a paste. Make sure you use the correct sessions for the respective worksheets.

Reply


Terms & ConditionsCookie settings