Skip to main content

Copy method

Table of contents
  1. Syntax
  2. Remarks

Copies a specified file or folder from one location to another.


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.


The results of the Copy method on a File or Folder are identical to operations performed by 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.

Leave a comment

Your email address will not be published. Required fields are marked *

Format your code: <pre><code class="language-vba">place your code here</code></pre>