| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Number Format on Excel File saved from .html file | Excel Discussion (Misc queries) | |||
| How to tell number of spaces between values in saved text file fromthe original xls file | Excel Discussion (Misc queries) | |||
| Create a batch file from a number of Excel File | Excel Programming | |||
| Number format in CSV file | Excel Programming | |||
| Error "52" bad file number or file name problem | Excel Programming | |||
Linear Mode
