Hi all,

I would like to ask in case anyone has experience about this.

So, I have a joined string that has different size every time I input it from matlab.

For example:
from Matlab into VBA
 input_to_vba = strjoin {'A, B, C, D'}
In this case, total number of the string is 4 (A to D).

in VBA
input_split = split(input_to_vba, '%')
A = input_split(1)
...
D = input_split(4)
I will have different string input everytime I run the matlab together with VBA. Can VBA automatically recognize it and make the split?

Thanks a lot!