FileCopy function Description
The VBA FileCopy function copies a file from the source directory to the destination directory.
VBA Reference – File Functions
The syntax for the ChDir function is:
FileCopy( source, destination )
The source file path of the file you want to copy.
The destination file path to which you want to copy the file to.
The FileCopy statement can be used in VBA. Let’s look at some FileCopy function examples:
FileCopy "C:\Source\test.txt", "C:\Destination\test.txt" 'Result: Copies file from "C:\Source" to "C:\Destination"