title: VBA to copy a file from one directory to another
body: <p>I have an access file that I regularly need to copy to another directory, replacing the last version.
  I would like to use an Excel macro to achieve this, and would also like to rename the file in the process.</p>
  <pre><code>   fileName = &quot;X:\Database\oldName.accdb&quot;
     copyDestination = &quot;Y:\dbstore\&quot;
     newName = &quot;newName.accdb&quot;
  </code></pre>
  <p>Is there an easy way of doing this?</p>