bad file name or number?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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_Hardware2004.xls",
"\\tfmafs01\corporatesecure$\Procurement
Reporting\ExportReportFolder\Working\Pre_Formatted_Backup\"

End sub
 
1. The destination must include a file name (not only foldername)

2. The file being copied must not be open (on any PC).

Sharad
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy files-what is wrong with this? 1
Copy Paste a file into a folder with the current dat 1
Copy .xls betwen local disk and https:// location 1
Copy Paste a file into a folder with the current date 1
MACRO to Approve or Decline 2
Excel 2007 & Vista OS 7
EXCEL CONNECTED WITH OUTLOOK 1
Bad File name or number 1

Back
Top