Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi All,
When using the method to copy files I get an error "Path Not Found" Filecopy "C:\Temp\t1\New Text Document.txt", "C:\Temp\" Do you have to specify the name of the destination file when copying individual files or can I use just the path? Ta Andi |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Andi,
From help. Required. String expression that specifies the target file name. The destination may include directory or folder, and drive. So it looks like the answer is yes, it does need a file name, but the path is optional. -- HTH Bob Phillips "Andibevan" wrote in message ... Hi All, When using the method to copy files I get an error "Path Not Found" Filecopy "C:\Temp\t1\New Text Document.txt", "C:\Temp\" Do you have to specify the name of the destination file when copying individual files or can I use just the path? Ta Andi |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I did read the help but it didn't make much sense to me (no change there
then :-)) "Bob Phillips" wrote in message ... Andi, From help. Required. String expression that specifies the target file name. The destination may include directory or folder, and drive. So it looks like the answer is yes, it does need a file name, but the path is optional. -- HTH Bob Phillips "Andibevan" wrote in message ... Hi All, When using the method to copy files I get an error "Path Not Found" Filecopy "C:\Temp\t1\New Text Document.txt", "C:\Temp\" Do you have to specify the name of the destination file when copying individual files or can I use just the path? Ta Andi |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I did read the help but it didn't make much sense to me (no change there
then :-)) Thanks Bob "Bob Phillips" wrote in message ... Andi, From help. Required. String expression that specifies the target file name. The destination may include directory or folder, and drive. So it looks like the answer is yes, it does need a file name, but the path is optional. -- HTH Bob Phillips "Andibevan" wrote in message ... Hi All, When using the method to copy files I get an error "Path Not Found" Filecopy "C:\Temp\t1\New Text Document.txt", "C:\Temp\" Do you have to specify the name of the destination file when copying individual files or can I use just the path? Ta Andi |