title: Is there a method for opening a copy of a document through VBA?
body: <p>I am relatively new to VBA and I need a solution to a problem I have.</p>
  
  <p>Currently I have two excel documents - one which is a form where the user enters data and this is then sent to a second document which acts as a database for this information.  My issue is that when people are looking in the database data cannot be sent to the second document because it is open and there are overwrite errors.</p>
  
  <p>It is my intention to have the databases location hidden away within a network drive so it cannot be found meaning the only way to access I is through a button on the first document.  </p>
  
  <p>Is there a way that when the open button is pressed to access the database that a copy of the document is opened instead of the actual document itself so data can still be sent?</p>