View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ronaldo Ronaldo is offline
external usenet poster
 
Posts: 3
Default VBA to copy and paste folder

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