Pass List string into invoke VBA code

[Mr.H]

Hi Everyone.

I have an list of string and want to pass into the invoke code VBA as attached pictured.

But it has something wrong so run not correct.

It has any incorrect point ?

Thanks in advance!

[kirankumar.mahanthi1 (Kirankumar Mahanthi)]

Hi @Mr.H ,

Your passing list of string so you have to use

List(Of String) instead of string in function. Please try. Thanks.

[Mr.H]

Hi Bro.

How to pass it into list(of string) into the invoke code??

Could you pls example.

Thanks you!

[kirankumar.mahanthi1 (Kirankumar Mahanthi)]

Sub Main(List_Jump_Range As List(Of String) ) give like this and try. I never used invoke VBA code. I have used invoke code and write vb code into it.

[Mr.H]

Thanks you Bro. But it not correct…

[supermanPunch (Arpan)]

Hi @Mr.H ,

Have you Checked the below post :

How to pass a List as parameter for Invoke VBA code Activity

You can pass this to VBA, where && = some unique separator eg if list = {“a”,“b”}, then this string will be a&&b String.Join("&&",New List(Of String)({"a","b"}).ToArray) In VBA split the string to list Dim Result() As String Result = Split(ListToString, "&&") Edit: you can also encode and decode it using Json serializer

[Mr.H]

Thanks you Bro!

[jack.chan]

Replying to your mail

1. declare new variable test

2. assign
   test = String.Join(“&&”,Jump_Range)

3. change entryMethodParameters to {test}
   

   

4. change Vba…

sub main(list_jump_range as string)
Dim Result() As String
Result = Split(list_jump_range, "&&")

Dim item as string
For Each item in Result
    'msgbox item
Next item

....