The FileSystemObject VBA CopyFile method copies one or more files from one a source to a destination location.
VBA CopyFile Syntax
fso.CopyFile source, destination, [ overwrite ]
The source location of the file or files. You can use wildcards such as *.* to specify more than a single file matching the pattern.
The destination location (folder) where the source files are to be copied to.
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
Set fso = CreateObject("Scripting.FileSystemObject")
'Copy just the Hello.xlsx file
fso.CopyFile "c:\Src\Hello.xlsx", "c:\Dest\"
'Copy all files with XLSX extension to destination folder
fso.CopyFile "c:\Src\*.xlsx", "c:\Dest\"
'Copy all files to destination folder
fso.CopyFile "c:\Src\*.*", "c:\Dest\"
'Copy all files in subfolders of C:\Src to destination folder
fso.CopyFile "C:\Src\*\*.*", "c:\Dest\"