I have the following Macro below and I wonder if anyone can help me modify it to do the following two things:
- Move to the next line when there's and error. Sometimes when a file is being copied to a folder, someone else has a file with the same name open.
- Create a new tab with a list of the lines that didn't run due to errors.
Thank you
Sub DRILL_XFER()
'
' DRILL PL TRANSFER MACRO
' TRANSFER DRILLS AND PLS DAILY DURING CLOSE
'
FileCopy "H:\File1 - 2018-12-31.xls", "H:\File1 - 12-2018.xls"
FileCopy "S:\File2.xls", "H:\File2 - 2018-12-31.xls"
MsgBox "Drill & PL Transfer is Complete"
End Sub
Bookmarks