Dim str As String
Dim aa() As String
Dim lngTmp As Long
Dim lngTemp As Long
Dim strString As String
Dim str1 As String
Dim i As Long
str = "01020312130105"
lngTmp = CLng(Left(str, 2))
str1 = Left(str, 2)
Do Until False
str = Right(str, Len(str) - 2)
If Len(str) < 1 Then Exit Do
lngTemp = CLng(Left(str, 2))
If lngTmp > lngTemp Then
str1 = str1 & "-"
lngTmp = lngTemp
str1 = str1 & Left(str, 2)
Else
lngTmp = lngTemp
str1 = str1 & Left(str, 2)
End If
Loop
aa = Split(str1, "-")
sub GetArrey(strtemp as string)
dim i as integer
dim tstr as string
for i=1 to len(strtemp)
tstr=mid(strtemp,i,6)
if len(tstr)=6 then
if val(right(tstr,2))-val(mid(tstr,3,2)=1 AND val(mid(tstr,3,2))-val(left(tstr,2))=1 then
debug.print tstr
end if
next i
end sub
sub GetArrey(strtemp as string)
dim i as integer
dim tstr as string
for i=1 to len(strtemp) step 6
tstr=mid(strtemp,i,6)
if len(tstr)=6 then
if val(right(tstr,2))-val(mid(tstr,3,2)=1 AND val(mid(tstr,3,2))-val(left(tstr,2))=1 then
debug.print tstr
end if
next i
end sub