Maybe :
Private Function CopyExcelFiles(SrcDir As String, TgtDir As String) As Long
If Right$(SrcDir, 1) <> "\" Then SrcDir = SrcDir & "\"
If Right$(TgtDir, 1) <> "\" Then TgtDir = TgtDir & "\"
If Len(Dir(SrcDir, vbDirectory)) = 0 Then CopyExcelFiles = 0: Exit Function
CopyExcelFiles = Shell("cmd /c xcopy """ & SrcDir & "*.xls*"" """ & TgtDir & """ /S /Y", vbHide)
End Function
Sub Test()
If CopyExcelFiles("C:\backup2018", "C:\Users\user\documents\excelfilesbackup2018") > 0 Then Debug.Print "Success copying files" Else Debug.Print "Fail copying files"
End Sub
Bookmarks