In VBA, you can use the FileCopy function.

You can also use the FileSystemObject of the Windows Scripting Runtime
library (scrrun.dll). This object is extremely useful and flexible but
requires a teeny bit more work than just using FileCopy. Google has lots of
info on the FileSystemObject.