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