SyntaxFix

[vba] VBA to copy a file from one directory to another

Use the appropriate methods in Scripting.FileSystemObject. Then your code will be more portable to VBScript and VB.net. To get you started, you'll need to include:

Dim fso As Object
Set fso = VBA.CreateObject("Scripting.FileSystemObject")

Then you could use 

Call fso.CopyFile(source, destination[, overwrite] )

where source and destination are the full names (including paths) of the file.

See https://docs.microsoft.com/en-us/office/vba/Language/Reference/user-interface-help/copyfile-method

Examples related to vba

• Copy filtered data to another sheet using VBA • Better way to find last used row • Check if a value is in an array or not with Excel VBA • Creating an Array from a Range in VBA • Excel: macro to export worksheet as CSV file without leaving my current Excel sheet • VBA: Convert Text to Number • What's the difference between "end" and "exit sub" in VBA? • Rename Excel Sheet with VBA Macro • Extract Data from PDF and Add to Worksheet • Quicker way to get all unique values of a column in VBA?

Examples related to copy

• Copying files to a container with Docker Compose • Copy filtered data to another sheet using VBA • Copy output of a JavaScript variable to the clipboard • Dockerfile copy keep subdirectory structure • Using a batch to copy from network drive to C: or D: drive • Copying HTML code in Google Chrome's inspect element • What is the difference between `sorted(list)` vs `list.sort()`? • How to export all data from table to an insertable sql format? • scp copy directory to another server with private key auth • How to properly -filter multiple strings in a PowerShell copy script