Be the first user to complete this post

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

file system object 22 excel-macro-vba 58