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