Hi I’ve today migrated a large project to remove Windows legacy support in Studio 2022.10.3. The only problem is with an Invoke VBA activity, where I’m passing parameters of differing types. In this case, it has two strings, 1 integer and two strings: {strWorkSheet_Name, strFilterRange, intFilte…

Update: The solution I proposed, to append to List of objects, is required. The alternative was to amend the VBA script to accept a list of strings, then convert one to integer, but that risks failure on data types inside the VBA on attempt to convert and I want to avoid that. If anyone has a mor…

Error on passing parameter array to Invoke VBA with different types

Help Activities

Anil_G (Anil Gorthi) November 25, 2022, 8:30pm 13

@ppr Nice one

@stevewakley yet another way and another reason

Topic		Replies	Views
PASS ARRAY AS VBA ARGUMENT THROUGH INVOKE VBA Activities excel , question , vba	3	24	May 22, 2025
How to pass a List as parameter for Invoke VBA code Activity Help studio , question	4	2229	December 17, 2020
Number of Parameters specified does not match the expected number Help	2	9418	June 22, 2019
Pass List string into invoke VBA code Academy Feedback academic_alliance , question	8	2052	January 6, 2022
2D array of uipath to Excel VBA Studio excel , uiautomation , studio , question , activities_panel	6	675	February 13, 2023

Error on passing parameter array to Invoke VBA with different types

Related topics