View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Brettjg Brettjg is offline
external usenet poster
 
Posts: 295
Default Copy a folder in VB

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