View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Vlad Vlad is offline
external usenet poster
 
Posts: 16
Default bad file name or number?

In regards to my previous post "Copyfiles wjat is wrong with this"?
I am getting a message "Bad file name or number". What is wrong with my file?

Sub CopyFiles ()
FileCopy "\\tfmafs01\corporatesecure$\Procurement
Reporting\ExportReportFolder\Working\Computer_Hard ware2004.xls",
"\\tfmafs01\corporatesecure$\Procurement
Reporting\ExportReportFolder\Working\Pre_Formatted _Backup\"

End sub