ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   bad file name or number? (https://www.excelbanter.com/excel-programming/320735-bad-file-name-number.html)

Vlad
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

Sharad Naik
bad file name or number?
 
1. The destination must include a file name (not only foldername)

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

Sharad

"vlad" wrote in message
...
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




All times are GMT +1. The time now is 02:55 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com