View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ken Macksey Ken Macksey is offline
external usenet poster
 
Posts: 77
Default 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