История страницы
...
The action starts macro in an Excel file that has its VBA-code in a separate text file.
Action icon
Action parameters
Input parameters
- "Context" field - a type of a Word document where the external macro will run.
- "File" field – path to the macro text file containing the VBA code
- "Procedure name" field - name of the called function or subroutine that is specified in the VBA code of the macro.
- "Parameters" field - 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.
Output parameters
Result - the value returned by the macro run.
...
Settings of parameters
| 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 | ||
...
Обзор
Инструменты контента