Copy Method (Visual Basic for Applications)
This page is specific to the Visual Basic for Applications (VBA) Language Reference for Office 2010.
Description
Copies a specified file or folder from one location to another.
Syntax
object.Copy destination[, overwrite]
The Copy method syntax has these parts:
Part |
Description |
|---|---|
object |
Required. Always the name of a File or Folder object. |
destination |
Required. Destination where the file or folder is to be copied. Wildcard characters are not allowed. |
overwrite |
Optional. Boolean value that is True (default) if existing files or folders are to be overwritten; False if they are not. |
Remarks
The results of the Copy method on a File or Folder are identical to operations performed using FileSystemObject.CopyFile or FileSystemObject.CopyFolder where the file or folder referred to by object is passed as an argument. You should note, however, that the alternative methods are capable of copying multiple files or folders.