Copy Excel Files to new directory
 

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.

Copy Excel Files to new directory
 

VBA supports FileCopy statement.

Did you use the FileCopy?

FileCopy source, destination


msn
---------------------------------------------
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.

Copy Excel Files to new directory
 

See this page Ray
http://www.rondebruin.nl/folder.htm

--

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


"Ray Clark" wrote in message ...
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.

Copy Excel Files to new directory
 

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" wrote in message ...
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.