|
Sub COPYFILES()
Dim FSO As Object
Dim SFD As Object
Dim SSFD As Object
Dim FL As Object
Set FSO = CreateObject("SCRIPTING.FILESYSTEMOBJECT")
For K = 1 To Range("A1048576").End(xlUp).Row
If Not FSO.FOLDEREXISTS("E:\CD\" & Cells(K, 1)) Then'建立文件夹
FSO.CREATEFOLDER ("E:\CD\" & Cells(K, 1))
End If
Next K
Set FD = FSO.GETFOLDER("E:\AB")
For K = 1 To Range("A1048576").End(xlUp).Row
For Each FL In FD.Files 'E:\AB"‘主文件夹
If FSO.GetFileName(FL) = Cells(K, 2) Then
FSO.COPYFILE FL, "E:\CD\" & Cells(K, 1) & "\"
End If
Next FL
Next K
Set FL = Nothing
Set SFD = FD.SubFolders '子文件夹
For K = 1 To Range("A1048576").End(xlUp).Row
For Each SSFD In SFD
For Each FL In SSFD.Files
If FSO.GetFileName(FL) = Cells(K, 2) Then
FSO.COPYFILE FL, "E:\CD\" & Cells(K, 1) & "\"
End If
Next FL
Next SSFD
Next K
MsgBox "OK"
End Sub
|
|