Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 103
Default Filecopy - Do you need to specify Destination Filename?

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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,272
Default Filecopy - Do you need to specify Destination Filename?

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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 103
Default Filecopy - Do you need to specify Destination Filename?

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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 103
Default Filecopy - Do you need to specify Destination Filename?

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







Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
filecopy Marvin Excel Programming 1 July 17th 05 06:34 PM
FileCopy Andibevan[_2_] Excel Programming 2 May 18th 05 02:58 PM
FileCopy Andibevan[_2_] Excel Programming 6 May 12th 05 10:13 AM
FileCopy Dana DeLouis[_5_] Excel Programming 0 August 11th 03 12:57 PM
FileCopy John Green[_2_] Excel Programming 1 August 5th 03 08:55 AM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"