|
- Sub 提取审批()
- arr = Range("a1").CurrentRegion
- Set d = CreateObject("scripting.dictionary")
- Range("c1").Resize(1, 100).EntireColumn.ClearContents
- For i = 1 To UBound(arr)
- d.RemoveAll
- brr = Split(arr(i, 1), Chr(10))
- For Each k In brr
- If InStr(k, "|审批|") Then
- crr = Split(k, "|")
- d(crr(0)) = CDate(crr(2))
- End If
- Next
- If d.Count > 0 Then
- Cells(i * 2 - 1, 3).Resize(1, d.Count) = d.keys
- Cells(i * 2, 3).Resize(1, d.Count) = d.items
- Cells(i * 2, 3).Resize(1, d.Count).NumberFormatLocal = "yyyy-mm-dd hh:mm:ss"
- End If
- Next
- End Sub
|
|