jkluio668
10/23/2017 - 1:02 PM

vba:move_to_checked

移动同路径下的文件到“checked”文件夹

Function check_folder(path1)
    If Dir(path1, vbDirectory) = "" Then
        'MsgBox "不存在此目录"
        MkDir path1
    End If
End Function
Function move_checked(file)
    check_folder (ThisWorkbook.Path & "\checked\")
    Name ThisWorkbook.Path & "\" & file As ThisWorkbook.Path & "\checked\" & file
End Function