Copying files

Robin Clay · Aug 4, 2004

Greetings !

I have the name and directory of a source file, and the
name of the target directory.

I was going to use

Shell "Copy " & Source & " " & Target

what VBA code could I use instead?

RClay AT haswell DOT com

Ron de Bruin · Aug 4, 2004

Hi Robin

Look at the FileCopy command in the VBA help

Robin Clay · Aug 4, 2004

Again, SO simple - WHEN you know how ! Thanks once more.

-----Original Message-----
Hi Robin

Look at the FileCopy command in the VBA help

--
Regards Ron de Bruin
http://www.rondebruin.nl

"Robin Clay" <[email protected]> wrote

in message news:[email protected]...