View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
oinker oinker is offline
external usenet poster
 
Posts: 1
Default 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.
.