FileCopy Statement

Office 2013 and later
GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

Copies a file.

Syntax

FileCopy source, destination

The FileCopy statement syntax has these named arguments:

Part

Description

source

Required. String expression that specifies the name of the file to be copied. The source may include directory or folder, and drive.

destination

Required. String expression that specifies the target file name. The destination may include directory or folder, and drive.

Remarks

If you try to use the FileCopy statement on a currently open file, an error occurs.

This example uses the FileCopy statement to copy one file to another. For purposes of this example, assume that is a file containing some data.

Dim SourceFile, DestinationFile 
SourceFile = "SRCFILE" ' Define source file name. 
DestinationFile = "DESTFILE" ' Define target file name. 
FileCopy SourceFile, DestinationFile ' Copy source to target. 

Show: