Copying files

[Robin Clay]

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]

Hi Robin

Look at the FileCopy command in the VBA help

 

[Robin Clay]

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