VB & VBA in a Nutshell: The Language

FileCopy Statement

Named Arguments

Yes

Syntax

FileCopy source, destination

source

Use: Required.

Data Type: String

The name of the source file to be copied.

destination

Use: Required.

Data Type: String

The name and location of the file when copied.

Description

Copies a file.

Rules at a Glance

• The source and destination arguments may contain a drive name and a folder name, but they must always contain the filename.

• You can't copy a file that is currently in an open state.

Programming Tips and Gotchas

• If you don't specify a drive or folder in either the source or destination, the file is assumed to be in the current drive or folder.

• Unlike copying a file from one folder to another from outside VB, when using the FileCopy statement, it isn't sufficient to simply enter a path for destination. You must supply a filename, even if it's the same as the source ; otherwise, runtime error 75, "Path/File access error" results.

• FileCopy is a statement and not a function; there is no return value. You therefore have to assume that if there are no errors generated from calling the FileCopy statement, the file has been successfully copied. So be sure to wrap FileCopy in robust error handling.

• Be aware that if the destination file already exists, it will be overwritten without warning.

• A number of functions allow you to use the copy operation to rename a file. (Typically, this is done by specifying the same path in the destination as in the source, along with a different filename.) The FileCopy ...