Copying files
 

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

Copying files
 

Hi Robin

Look at the FileCopy command in the VBA help

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


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

Copying files
 

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


.