PC Review


Reply
Thread Tools Rate Thread

Copy Excel Files to new directory

 
 
=?Utf-8?B?UmF5IENsYXJr?=
Guest
Posts: n/a
 
      18th Apr 2007
I have tried various macros to automate the copying of files from one
directory to another but none of them appear to work. I keep getting error
messages.
 
Reply With Quote
 
 
 
 
=?Utf-8?B?dGltZWJpcmQ=?=
Guest
Posts: n/a
 
      18th Apr 2007
VBA supports FileCopy statement.

Did you use the FileCopy?

FileCopy source, destination


msn (E-Mail Removed)
---------------------------------------------
the best time to plant a tree was twenty years ago.
the second best time, is today - Chinese proverb



"Ray Clark" wrote:

> I have tried various macros to automate the copying of files from one
> directory to another but none of them appear to work. I keep getting error
> messages.

 
Reply With Quote
 
Ron de Bruin
Guest
Posts: n/a
 
      18th Apr 2007
See this page Ray
http://www.rondebruin.nl/folder.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Ray Clark" <(E-Mail Removed)> wrote in message news:B192CD23-B223-4060-8127-(E-Mail Removed)...
>I have tried various macros to automate the copying of files from one
> directory to another but none of them appear to work. I keep getting error
> messages.

 
Reply With Quote
 
=?Utf-8?B?UmF5IENsYXJr?=
Guest
Posts: n/a
 
      18th Apr 2007
Ron,

Thanks for your help managed to get this working. Much appreciated.

"Ron de Bruin" wrote:

> See this page Ray
> http://www.rondebruin.nl/folder.htm
>
> --
>
> Regards Ron de Bruin
> http://www.rondebruin.nl/tips.htm
>
>
> "Ray Clark" <(E-Mail Removed)> wrote in message news:B192CD23-B223-4060-8127-(E-Mail Removed)...
> >I have tried various macros to automate the copying of files from one
> > directory to another but none of them appear to work. I keep getting error
> > messages.

>

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help to copy files names in a column from one directory to another directory VBA Paul B Microsoft Excel Programming 4 10th Nov 2008 01:54 AM
how to search in a directory path for excel files and copy to acce =?Utf-8?B?Z29rb3A=?= Microsoft Access Form Coding 5 25th Aug 2007 10:26 AM
Would like to write batch file to copy all TXT files in a given directory and all subdirectories to a single target directory. Rob Windows XP General 5 20th Aug 2007 02:42 PM
Copy all files from one directory to another directory Phil Microsoft Access Form Coding 15 14th Mar 2004 03:21 PM
Copy all files and sub-directory under a specific directory Phil Microsoft Access 1 20th Dec 2003 11:06 AM


Features
 

Advertising
 

Newsgroups
 


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