View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
joel joel is offline
external usenet poster
 
Posts: 9,101
Default Copy a folder in VB

This works. I changed the directory. You had "new" in the file. I think
the code you used was from a C#, or C++ compiler.

Sub CopyFolder()
Dim fso
Set fso = CreateObject("Scripting.FileSystemObject")
fso.CopyFolder "c:\temp\old", "c:\temp\new"
End Sub


"Brettjg" wrote:

Can someone help me on this one please. I want to use a macro to do backups,
but the following code work. My sub does have a different name, but surely
that doesn't matter.

Sub CopyFolder()
Dim fso As Scripting.FileSystemObject
Set fso = New Scripting.FileSystemObject
fso.CopyFolder "c:\old", "c:\new"
End Sub

Thanks, Brett