Copy a file in VBA
 

Whoa...new format, okay, I could get used to this!

I need to copy a closed file using VBA in Excel XP from one folder into another folder. I can't quite remember the syntax. Isn't it something like:

File [SourceFullName] Copy [DestinationPath]

Could someone please supply a complete example to clear me up?

Thanks in advance for your assist.

Copy a file in VBA
 

Sub CopyFiles()

FileCopy "C:\book1.xls", "S:\textbook1.xls"


End Sub
-----Original Message-----
Whoa...new format, okay, I could get used to this!

I need to copy a closed file using VBA in Excel XP from
one folder into another folder. I can't quite remember
the syntax. Isn't it something like:

File [SourceFullName] Copy [DestinationPath]

Could someone please supply a complete example to clear
me up?

Thanks in advance for your assist.
.