UiPath | Execute Excel Macro in UiPath | Execute Macro Full Tutorial
#rpa #uipath #excel
👉 𝐄𝐧𝐠𝐥𝐢𝐬𝐡
● This video is about the activity: Execute Macro.
● The video covers the following points:
📝 What are the properties of this activity?
📝 What is the difference between Sub and Function?
📝 How to add input parameters for a macro?
📝 How to use Output from a macro?
𝗘𝗫𝗘𝗖𝗨𝗧𝗘 𝗠𝗔𝗖𝗥𝗢: • UiPath | Execute Excel Macro in UiPat...
𝗜𝗡𝗩𝗢𝗞𝗘 𝗩𝗕𝗔: • UiPath | INVOKE VBA | Invoke VBA Full...
🌟 𝗖𝗼𝗱𝗲
✔ Sub Macro
Sub ShowMessage (TextToShow as String)
MsgBox TextToShow
End Sub
✔ Function Macro
Function SumTwoNumbers (x as Integer, y as Integer) as Integer
SumTwoNumbers = x + y
End Function
🕜 𝗖𝗵𝗮𝗽𝘁𝗲𝗿𝘀
► 00:00 Introduction
► 00:40 Macro Properties
► 02:15 Sub Vs. Function
► 03:02 Macro Structure
► 04:44 1. Example (no Parameters)
► 07:47 2. Example (1 Parameter)
► 09:13 3. Example (2 Parameters of type String)
► 10:38 4. Example (2 Parameters of type Integer)
► 12:02 5. Example (2 Parameters + MacroOutput)
► 14:09 6. Example (5 Parameters + MacroOutput)
► 15:44 7. Example (Parameters as variables)
► 17:22 Conclusion
📝 𝐏𝐫𝐨𝐜𝐞𝐝𝐮𝐫𝐞
➊ Add Excel Application Scope Activity + Excel Path
➋ Add Execute Macro Activity
➌ Add the MacroName
➍ Add the MacroParameters
➎ Create a variable of type Object to store the MacroOutput
➏ Run UiPath
✍ 𝗞𝗲𝘆 𝗪𝗼𝗿𝗱𝘀
→ UiPath
→ UiPath Automation
→ UiPath Activity
→ Macro in UiPath
→ Execute Macro activity
→ Execute Excel Macro in UiPath
→ Difference between Sub and Function
→ Macro Sub Vs. Function
→ Macro Parameters
→ Macro Input
→ Macro Output
→ Macro Name
→ Excel Application Scope
𝗙𝗼𝗹𝗹𝗼𝘄 𝘂𝘀
📰 𝗙𝗮𝗰𝗲𝗯𝗼𝗼𝗸 𝗣𝗮𝗴𝗲: / actautomate
📌 𝗙𝗮𝗰𝗲𝗯𝗼𝗼𝗸 𝗚𝗿𝗼𝘂𝗽: / 3241715929443302
💼 𝗟𝗶𝗻𝗸𝗲𝗱𝗜𝗻: / 70939125
📸 𝗜𝗻𝘀𝘁𝗮𝗴𝗿𝗮𝗺: / actautomate
📢 𝗬𝗼𝘂𝗧𝘂𝗯𝗲 𝗦𝗵𝗼𝗿𝘁𝘀: @ActAutomateShorts
👍 𝗦𝘂𝗯𝘀𝗰𝗿𝗶𝗯𝗲: / @actautomate