Articles → UiPath → Invoke VBA Activity In Uipath

Invoke VBA Activity In Uipath






Purpose





Settings




  1. Open excel file.
  2. Go to "File" → "Options" → "Trust Center" → "Trust Center Settings" → "Macro Settings".
  3. Check the checkbox - "Trust Access to the VBA project object model"
  4. Picture showing the Macro Settings option in the Trust window

    Click to Enlarge



Sample VBA File




Picture showing the sample code in VBA file

Click to Enlarge


Example




  1. Drag and drop the "Excel Application Scope" activity.
  2. Inside the "Excel Application Scope" activity, add the "Invoke VBA" activity.
  3. Picture showing the Invoke VBA activity inside the Excel Application Scope activity

    Click to Enlarge



Output


Picture showing the output of Invoke VBA activity in UiPath

Click to Enlarge


Posted By  -  Karan Gupta
 
Posted On  -  Monday, January 18, 2021

Query/Feedback


Your Email Id  
 
Subject 
 
Query/FeedbackCharacters remaining 250