VBA CopyFile

1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading...

The FileSystemObject VBA CopyFile method copies one or more files from one a source to a destination location.

VBA CopyFile Syntax

source
The source location of the file or files. You can use wildcards such as *.* to specify more than a single file matching the pattern.
destination
The destination location (folder) where the source files are to be copied to.
overwrite
Optional. If True will overwrite files with same name in destination folder. If True it will omit files for which there is an existing filename in the destination folder.

VBA CopyFile Examples

Simply the best place to learn Excel VBA