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

1 Like