白皮书下载
实在智能Agent产品白皮书(7.2.0).pdf
Execute macro
发刊日期：
2021/10/15
编辑团队：
实在学院
1、 Video example
To be launched.
2、 Function description
Execute the macro in the specified sheet of the target excel. You can customize the macro and set the macro parameters (only. Xlsm format files that start the macro are supported).
3、 Attribute description
● Output to variable: assign the returned result of the component to a variable.
● Workbook object: the excel workbook object variable that has been opened.
● Macro definition: enter the macro statement to be executed.
● Macro parameters: enter the parameters required to execute the macro.
4、 Use example
1. Execution logic
(1) Record macros in Excel and save them as macro enabled workbooks (. Xlsm);
(2) RPA process: open excel and the component & ldquo; Macro definition & rdquo; Parameter, enter the macro name in Excel.
2. Output results
Original data
Post execution data
