Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Returns a Variant that represents an array of the individual items in the specified string separated by the specified character string.
expression.SplitArgs(String, Tokens)
*expression * Required. An expression that returns one of the objects in the Applies To list.
String Required String. The string containing the data.
Tokens Required String. The character string that separates the items in the String parameter.
Remarks
The SplitArgs method is similar to the Split function in Microsoft Visual Basic; however, the SplitArgs method will not break quote-delimited strings.
Example
The following example splits the specified string into an array of the items in the specified string that are separated by a comma.
Dim varArray() As Variant
varArray = Application.SplitArgs("this,is a,test", ",")
Applies to | Application Object