Copy a file in VBA

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
Click to expand...
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.
.
Click to expand...
 
Back
Top