A group of actions: Excel
Action launches a macro in the Excel file, the VBA code of which is specified in a separate text file. In the security settings, the checkbox „Trust access to the VBA project object model“ must be selected.
Settings
| Property | Description | Type | Filling example | Mandatory field |
| Parameters | ||||
| Context | Action context for working with an Excel document. | Robin.Excel | Excel context | Yes |
| PathToFile | Path to the macro text file containing the VBA code. | Robin.FilePath | Yes | |
| Procedure name | Name of the called function or subroutine that is specified in the VBA code of the macro. | Robin.String | Yes | |
| Parameters | Values of the input parameters of the called function or subroutine in the macro code. If it is necessary to specify several parameters, the user must specify in this field a collection containing these parameters. Parameter values must be specified in the same order in which these parameters are specified in the called function. | Robin.Object | No | |
| Results | ||||
| Result | Value returned by the running macro. If the specified macro returns nothing, the result of the action will be empty. | Robin.Object | ||
Обзор
Инструменты контента