Split string to values

[nic]

Hi
Im using excel to get rgb values for colouring objects and would like to find a way of using coreldraw's VBA to convert a string with values in the format "127, 23, 250" (ie a string containing 3 numbers separated by 2 commas) to 3 separate variables each containing a numerical value.

Help appreciated.

nic

[shark]

Private Sub TestSplit()
Dim Test As Variant
    Test = Split("127, 23, 250", ",")
End Sub

After this code Test(0) contains 127, Test(1)=23 and test(2)=250

[nic]

Thanks Shark - really appreciate your help.
nic