Description |
Extended macro functionality for MS Excel to call a given macro with up to ten input parameters. Please note these activities are not mandatory to be used within Excel application scope. The Excel sheet gets attached to the UiPath with the workbook name provided as input. |
Prerequisites |
NA |
Execution |
Kindly import the NuGet package to use the activities |
Inputs |
RunMacrowithParameters
WorkbookName (string) - Optional. Default to be the active Workbook. Use *full path* and filename to workbook if using multiple instances of Excel.
MacroName (string) – Required macro to run. This can be either a string with the macro name, a Range object indicating where the function is, or a register ID for a registered DLL (XLL) function. If a string is used, the string will be evaluated in the context of the active sheet. Example: CommandButton2_Click"
Parameters (string) – Single row collection with one field per parameter required. Supports up to ten input parameters(mandatory).
OpenWorkbookByPassword
WorkbookFullPath (string) - Required. Full Path of Workbook
Password (string) - Optional. If no password, just leave it empty.
MaxTimeForWaiting (int) - Optional. Default to be 120s.
CloseAllInstances
Nil |
Outputs |
RunMacrowithParameters
Success (bool) – True if succeeded
ErrorMes (string) – Error message if any
OpenWorkbookByPassword
WorkbookFullPath (string) - Required. Full Path of Workbook
Password (string) - Optional. If no password, just leave it empty.
MaxTimeForWaiting (int) - Optional. Default to be 120s.
CloseAllInstances
Nil
|
Components Included |
Process Main NuGet Package
MSExcelMacros |
List of Functionality |
RunMacrowithParameters
Runs the specified macro or trigger events, passing parameters to the macro from the Input Parameters collection. Supports between 1 - 10 input parameters.
IMPORTANT: parameters must be passed by position.
Depending on how the macro has been created the name will be one of the following:
A. Just the macro name e.g. MyMacro
B. The workbook and macro name. Can be used for Form Controls' events e.g. FormControl.xlsm!ButtonTest1_Click
C. The workbook, worksheet and the macro name. Can be used for ActiveX Controls' events e.g. FormControl.xlsm!Sheet1.CommandButton2_Click
OpenWorkbookByPassword
The handler is from the default instance which is the first instance. This function could open the Excel file directly from Remove Server by using the http or https path or UNC path, while the standard Excel VBO could only use UNC path.
CloseAllInstances
Closes all instances of excel which have been opened by this business object, either through "Create Instance" or "Open Instance" and which have not been discarded through "Close Instance" or "Release Instance" |
Disclaimer: References in this site to UiPath products, activities or services or the use of any UiPath trade name are made solely to indicate compatibility of products available on RPA Marketplace with UiPath products, and do not constitute or imply the development, endorsement, recommendation or approval by UiPath of the same.
No posts found