you can do by this way:
strFinalArray = "FTWPRNADMIN01,PHDPRN01,PHDPRN02,SVFTWPRN01,SVFTWP RN02"
strPrintServers = Split(strFinalArray,",")
With that you build an array same as :
strFinalArray(0)="FTWPRNADMIN01"
strFinalArray(1)="PHDPRN01"
strFinalArray(2)="PHDPRN02"
strFinalArray(3)="SVFTWPRN01"
strFinalArray(4)="SVFTWPRN02"
It to simple to use,
Warn, if you use split with crlf, this can't work, Split work with 1 char and CRLF equal 2 char.
you must do it before :
mystring = replace(mystring,vbcrlf,vbcr)
Great.
|