it seemed to have slipped my mind, anyone know the split command? thanks!
Printable View
it seemed to have slipped my mind, anyone know the split command? thanks!
see vb help (MSDN), but it basicly splits a string into an array based on a delimiter (like a space)
Data = this:string
Commandx = Split(data, ":")(0)
msgbox commandx
commandx = "this"
did that make sense?
Code:sMyString = "One,Two,Three"
'Split the string into an Array whenever a comma is found
sArray = Split(sMyString, ",")
'Loop through the array and display the result
For I = LBound(sArray) To UBound(sArray)
Print sArray(I)
Next I