Copying file

A

AC

Hi

How can I copy a file to a path via vba?

Thanks

Regards
Click to expand...


Hi.

You can use the "FileCopy" statement

Syntax: FileCopy strSource, strDestination

strSource = string with full path and file name
strDestination = string of destination folder

Make sure you check the file you are copying is closed, if you try to
use the FileCopy statement on a currently open file, an error occurs.


HTH
AndyC
 
Top