cancel
Showing results for 
Search instead for 
Did you mean: 

Excel Macros

Anonymous
Not applicable
Hi RPA Developers   I currently having a challenge, I have two separate workbooks. I want to copy data from (one) excel workbook which is stored in xlsx and it opens and shoes workbook fine  and paste it into another (second) workbook, the second excel workbook type storage is xlsm, it is unable to open and show workbook. Can you anyone kindly assist? Thank you. Kind Regards: Kgwadi Moloto  
1 REPLY 1

Anonymous
Not applicable
Hi, If there is any macro enabled to run while opening the excel, u may face this issue. To resolve the same, please use the 'Set Events Enabled' enabled action which is available under MS Excel VBO. make sure that enable events flag set as 'False'. Use this in between the stages create handle and Open workbook. good luck.