Be the first user to complete this post

  • 0
Add to List

FileSystemObject : MoveFolder Method

Description: 

This function moves a Folder from one location to another.

Format : 

objectOfFileSystemObject. MoveFolder (source, destination );

Arguments: 
  • objectOfFileSystemObject

As the names says, it’s a FileSystemObject.

  • source
    • Mandatory
    • Type:     String
    • Path of a folder to be moved.
  • destination
    • Mandatory
    • Type:     String
    • Path where folder to be moved.
Function FnMoveFolder(strSourcePath,strDestinationPath)

      Set fso = CreateObject("Scripting.FileSystemObject")

      Set objFolder = fso. MoveFolder(strSourcePath, strDestinationPath)

End Function

Call FnMoveFolder ("c:\New Folder",”d:\New Folder”)



Also Read:

  1. Excel-VBA : Insert Multiple Images from a Folder to Excel Cells
  2. FileSystemObject : GetAbsolutePathName Method
  3. VBA-Excel: Add/Insert multiple objects from a folder in an Excel Document.
  4. FileSystemObject : CopyFolder Method