View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Alasdair Stirling[_3_] Alasdair Stirling[_3_] is offline
external usenet poster
 
Posts: 17
Default VBA to copy and paste folder

Try the following:

FileSystemObject.CopyFolder copy_dir, paste_dir

Regards,

Alasdair Stirling

"Ronaldo" wrote:

I need help with some code to copy a folder from one destination and paste it
to another.

Sub Transfer()

Dim copy_dir As String
Dim paste_dir As String

copy_dir = "C:\test_source"
paste_dir = "C:\test_destination"

FileCopy copy_dir, paste_dir

It seems that filecopy is not the answer, I need something like foldercopy.
Is there a VBA command to copy and paste folders and contents similr to
filecopy?

Thanks
Ronaldo