Two ParamArrays as Parameter in Function

Question

I was just trying to write a function like this:

Public Function myGetAttribute(ByVal xmlFileName As String, _
                                   ByVal ParamArray elementV() As String, _
                                   ByVal ParamArray attributesV() As String) As Collection

This is not working

"End of parameter list expected. Cannot define parameters after a paramarray parameter."

Why is it not possible to put two paramarrays as parameters and what is a workaround?

Because it's impossible to determine where the first array ends and starts the second — Veikedo, May 08 '14 at 09:43
but the arrays have different names shouldnt it be possible to deterine where the first array ends and the second starts? svick: sorry, I edited the post. — ruedi, May 08 '14 at 09:50

score 1 · Accepted Answer · answered May 08 '14 at 10:30

There can be only one ParramArray and it has to be the last. It looks like you want pass two arrays as parameters to your sub and not an an unknown number of parameters.

Public Function myGetAttribute(ByVal xmlFileName As String, _
                                   ByVal elementV() As String, _
                                   ByVal attributesV() As String) As Collection

More here: MSDN

Two ParamArrays as Parameter in Function

1 Answers1