MS Excel - Macros for UiPath Studio

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"