#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 295
Default Copy file

I want to copy a file from one folder to another by using a macro. Can
someone help please?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default Copy file

Look at filecopy in vba's help.

There's an example, too.

Brettjg wrote:

I want to copy a file from one folder to another by using a macro. Can
someone help please?


--

Dave Peterson
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 295
Default Copy file

Thank you so much Dave. I had spent hours looking in help for the right
thing, but could not make it work. This works. Thank you for replying so
promptly
Regards Brett.

"Dave Peterson" wrote:

Look at filecopy in vba's help.

There's an example, too.

Brettjg wrote:

I want to copy a file from one folder to another by using a macro. Can
someone help please?


--

Dave Peterson

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
How do I copy a file and attach a date to the name of the file hccatmo Excel Discussion (Misc queries) 1 February 23rd 07 08:21 PM
When I save/change a file, it creates a "copy" of the same file Renee Excel Discussion (Misc queries) 2 October 26th 06 08:51 PM
EXCEL FILE a copy/a copy/a copy ....filename ve New Users to Excel 1 September 29th 05 09:12 PM
copy excell file to a CSV file and than to Notepad need to know bob Excel Discussion (Misc queries) 0 August 23rd 05 07:27 PM
copy/paste from one file to another without file name reference slvrblt Excel Discussion (Misc queries) 4 February 6th 05 08:57 PM


All times are GMT +1. The time now is 11:08 AM.

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

About Us

"It's about Microsoft Excel"