FileSystemObject : CopyFile Method

by 
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”)