title: excel vba - copy file from one folder to another but if file exists do not overwrite?
body: <p>Can someone please show me a way of copying a file from one folder to another using vba but with a condition to say if file already exists do not overwrite?</p>
  
  <p>here is my code:</p>
  
  <pre><code>If Target.Column = Range("BL1").Column And Target.Row &gt; 14 Then
    FileCopy "\\UKSH000-FILE06\purchasing\New_Supplier_Set_Ups_&amp;_Audits\assets\audit.xls", "\\UKSH000-FILE06\purchasing\New_Supplier_Set_Ups_&amp;_Audits\ATTACHMENTS\" &amp; Range("B" &amp; ActiveCell.Row) &amp; "\audit.xls"
   End If
  </code></pre>