Look at FileCopy in VBA's help.

And if you wanted to move the file, look at Name in VBA's help.


Jeff wrote:

Hi,

I want to copy a file from one folder to another in VBA. Normally I would
open the file and then use savesas, but the file is a csv and you cannot open
in excel.

So is there a way to just copy the file?

Thanks

--

Dave Peterson