dim a() as string a = split(str1, vbtab) for i=0 to ubound(a) debug.print a(i) next i
dim myString as string dim strArr() as string dim i as integermystring ="aaa{tab}bbb{tab}ccc"strArr=split(mystring,vbTab)for i=0 to ubound(strArr)-1 debug.print i,strArr(i) next i
Private Sub Command1_Click() Dim ls_Content() As String Dim LogCount As Long Dim I As Long Dim strTemp As StringstrTemp = "aa" & vbTab & "bb" & vbTab & "cc" ls_Content = Split(strTemp, vbTab) LogCount = UBound(ls_Content, 1)For I = 0 To LogCount Debug.Print Trim(ls_Content(I)) Next I End Sub
dim myString as string dim strArr() as string dim i as integermystring ="aaa" & vbtab &"bbb" & vbtab & "ccc"strArr=split(mystring,vbTab)for i=0 to ubound(strArr)-1 debug.print i,strArr(i) next i
a = split(str1, vbtab)
for i=0 to ubound(a)
debug.print a(i)
next i
dim strArr() as string
dim i as integermystring ="aaa{tab}bbb{tab}ccc"strArr=split(mystring,vbTab)for i=0 to ubound(strArr)-1
debug.print i,strArr(i)
next i
Dim ls_Content() As String
Dim LogCount As Long
Dim I As Long
Dim strTemp As StringstrTemp = "aa" & vbTab & "bb" & vbTab & "cc"
ls_Content = Split(strTemp, vbTab)
LogCount = UBound(ls_Content, 1)For I = 0 To LogCount
Debug.Print Trim(ls_Content(I))
Next I
End Sub
dim strArr() as string
dim i as integermystring ="aaa" & vbtab &"bbb" & vbtab & "ccc"strArr=split(mystring,vbTab)for i=0 to ubound(strArr)-1
debug.print i,strArr(i)
next i