Excel with vba code

Help Studio
1

Hello All,

I am a new UiPath user and I need help to create an automation using UiPath. I had a excel with vba code behind it and I need to create a workflow to click a button in excel and it will execute my vba code and then copy the result to another excel sheet.

Thank you

2

@tommy.duong,

Welcome to the UiPath Community!

  1. Use excel process scope activity
  2. Use Use Excel File activity inside step 1
  3. Use Execute Macro activity and pass the Function or Sub name which is assigned to that macro button. You don’t need to click on that button.

Follow these steps and you would be sorted.

Thanks,
Ashok :slightly_smiling_face: