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

ppr (Peter Preuss) November 25, 2022, 8:12pm 12

As .net X IS compiled IT needs datatype clearness

Offen IT helped when Just Changed to

New Object() {strWorkSheet_Name, strFilterRange, intFilterColumnIndex, strFilterColumnValue}

1 Like

Topic		Replies	Views
How to pass a List as parameter for Invoke VBA code Activity Help studio , question	4	1908	December 17, 2020
Number of Parameters specified does not match the expected number Help	2	8568	June 22, 2019
Pass List string into invoke VBA code Academy Feedback academic_alliance , question	8	1615	January 6, 2022
Passing Variable using through Invoke VBA activity Help activities , variable , question	14	4838	June 18, 2022
Need help at VB Code To enter variables Studio studio , question , activities_panel	8	237	December 2, 2023

Most Active Users - Yesterday
ashokkarale
anjani_priya
Dheerendra_vishwakarma
Parvathy
Aakash_Singh_Rawat
Luis_Fernando
bjorn2390
neco
pere
Shiva_Nikhil
More details...

Error on passing parameter array to Invoke VBA with different types

Related Topics