Receiving Type mismatch error
Code: Sub Generate_Xmls Dim ColName(), new_nodes() Dim Nodes() 'Array storing the current splited node names Dim NodeStack() 'Array storing the last node names ...
- Short answer: change
to
Long answer: Use Dim with parentheses only if you assign array elements manually, like this:
If you use arrays returned by functions or subroutines, you need to Dim array variables without parentheses:
Dim arr(5)
For i = 0 To 5
arr(i) = i
Next
Dim arr
arr = Split("a b c", " ")
