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 ...
Get VB & VBA in a Nutshell: The Language now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.