|
- Sub Macro1()
- Dim fs, w, mypath$$, i&, j%, wj$$, wj2$$
- Set fs = CreateObject("scripting.filesystemobject")
- mypath = ThisWorkbook.Path & ""
- w = Array("H2S证", "HSE证", "井控证", "司钻证")
- For i = 2 To Range("a65536").End(xlUp).Row
- For j = 0 To UBound(w)
- wj = mypath & w(j) & "" & Cells(i, 1) & ".jpg"
- wj2 = mypath & "查找人员" & "" & Cells(i, 1) & j + 1 & ".jpg"
- If fs.FileExists(wj) Then fs.CopyFile wj, wj2
- Next
- Next
- MsgBox "OK"
- End Sub
复制代码 |
|