MS Excel - Macros for UiPath Studio

Hover over an image to enlarge

$0.00
Q4 Associates

This product is electronically distributed.

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

Write a review
Immediately Available

Most products are downloadable and available immediately after purchase

Quality assurance and service

We vet all products for quality and best practise

Refunds within 20 days

You have 20 days to test your purchase and request a refund if it doesn't meet your expectations