|
楼主 |
发表于 2022-6-5 15:42
|
显示全部楼层
找到这个代码,不过运行有点问题,还有2个函数不知道怎么加进去
Private Sub CommandButton1_Click()
Dim Fso As Object
Set Fso = CreateObject("Scripting.FileSystemObject")
Dim fs, f, f1, fc
On Error Resume Next
Set fs = CreateObject("scripting.filesystemobject")
Set f = fs.GetFolder("C:\FolderA")
Set fc = f.Files
If Err.Number <> 0 Then
MsgBox "From Folder Open Error!" & vbCrLf & Err.Description & vbCrLf
GoTo Err
End If
On Error GoTo 0
For Each f1 In fc
If (Right(f1, 3) = "xls" Or Right(f1, 4) = "xlsx") And InStr(1, f1, "OK") <= 0 Then
On Error Resume Next
Fso.CopyFile f1, SetFolderPath("C:\FolderB")) & GetFileName(f1)
If Err.Number <> 0 Then
MsgBox "File Copy Error!" & vbCrLf & Err.Description
GoTo Err
End If
On Error GoTo 0
End If
Next
MsgBox "File Copy is over."
Err:
Set fs = Nothing
Set f = Nothing
Set f1 = Nothing
Set fc = Nothing
Set Fso = Nothing
End Sub |
|