FileSystemObject : CopyFolder Method

Description: 

This function copies a Folder from one location to another.

Format : 

objectOfFileSystemObject. CopyFolder (source, destination[, overwrite] );

Arguments: 

• objectOfFileSystemObject
  • As the names says, it’s a FileSystemObject.

• source
  • Mandatory
  • Type:     String
  • Path of a folder to be copied.
• destination
  • Mandatory
  • Type:     String
  • Path where folder to be copied.
• overwrite
  • Optional
  • Type: Boolean ( True(default): if existing folder to be overwritten, False: if not overwritten)

Function FnCopyFolder(strSourcePath,strDestinationPath)       
   Set fso = CreateObject("Scripting.FileSystemObject")     
  Set objFolder = fso. CopyFolder(strSourcePath, strDestinationPath)
End Function

Also Read:

1. FileSystemObject : GetExtensionName Method
2. FileSystemObject in Excel Macro
3. FileSystemObject : CreateTextFile Method
4. Excel-VBA : Insert Multiple Images from a Folder to Excel Cells