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.
.
|