Copying files to to new folder using vba???

**jonn** · 09-09-2008, 04:06 PM

Hi,

is there a way to copy files in a folder and paste them to a new folder in vba?

thanks

jon

**dominicb** · 09-09-2008, 06:45 PM

Good evening jonn

Originally Posted by jonn

is there a way to copy files in a folder and paste them to a new folder in vba?

No need to copy and paste : just rename, thus :

Name "C:/test.xls" As "C:\work\test.xls"

HTH

DominicB

**shg** · 09-09-2008, 07:03 PM

Name moves files; I think you want

FileCopy "C:\srcPath\srcFile", "C:\destPath\destFile"