Be the first user to complete this post

  • 0
Add to List

FileSystemObject : CopyFile Method

Description: 

This function copies one or more files from one location to another.

Format : 

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

Arguments: 
  • objectOfFileSystemObject

As the names says, it’s a FileSystemObject.

  • source
    • Mandatory
    • Type:     String
    • File name to be copied.
  • destination
    • Mandatory
    • Type:     String
    • Path where file to be copied.
  • overwrite
    • Optional
    • Type: Boolean ( True(default): if existing files to be overwritten, False: if not overwritten)
       Function FnCopyFile(strSourceFile,strDestinationPath)

           Set fso = CreateObject("Scripting.FileSystemObject")

           fso. CopyFile(strSourceFile, strDestinationPath)

      End Function

Call FnCopyFile(“c:\mydocuments\file.xls”,”c:\NewFolder”)



Also Read:

  1. FileSystemObject : CopyFolder Method
  2. FileSystemObject : CreateTextFile Method
  3. FileSystemObject : MoveFile Method
  4. FileSystemObject : GetParentFolderName Method
  5. FileSystemObject : GetFolder Method
  6. FileSystemObject : DriveExists Method
  7. FileSystemObject : GetAbsolutePathName Method
  8. FileSystemObject : FileExists Method