- Sub tiqu()
- Dim fileN$, cxFile$, str$, arr, i&, j&, k&
- fileN = ThisWorkbook.Path & ""
- cxFile = Dir(fileN & "*.jpg")
- str = Mid(Right(cxFile, 7), 1, 3)
- Do While cxFile <> ""
- cxFile = Dir
- str = str & "," & Mid(Right(cxFile, 7), 1, 3)
- If cxFile = "" Then Exit Do
- Loop
- arr = Split(Mid(str, 1, Len(str) - 1), ",")
- For i = 0 To UBound(arr)
- k = Application.Max(j, CLng(arr(i)))
- j = CLng(arr(i))
- Next
- Sheet1.[A2] = "img" & Mid(CStr(1000 * 1 + k), 2, 4)
- Sheet1.[A3] = "img" & Mid(CStr(1000 * 1 + k - 1), 2, 4)
- End Sub
复制代码 |