Copy files-what is wrong with this?
Hi
Use a msgbox to see if your paths are correct before you copy it, something
like this. When you get it right, rem out the message box and remove the rem
from the file copy command.
Dim fPath As String, lPath As String
fPath =
"C:\tfmafs01\corporatesecure$\ProcurementReporting \ExportReportFolder\Working\"
lPath =
"C:\tfmafs01\corporatesecure$\ProcurementReporting \ExportReportFolder\Working\Pre_Formatted_Backup"
MsgBox fPath & "*.*" & "," & lPath
'FileCopy fPath & "*.*", lPath
HTH
Ken
|