title: Reference opened Wokrbook & Create error message if workbook is in use
body: <p>Hi I have the below code, I would like to reference the workbook so I can copy and paste data from an already opened work book. However I am struggling to reference the workbook correctly. Can anyone help? :)</p>
  
  <p>File name is "Pics &amp; Benefits upload file.xlsm"   </p>
  
  <pre><code>    Workbooks.Open Filename:= _
      "U:\FBS\PROJECTS_TEAM\MI\Sean's Projects\PICS and Benefits\Pics &amp; Benefits upload file.xlsm"
  
  Dim PicsFile As String
  PicsFile = "Pics &amp; Benefits upload file.xlsm"
  </code></pre>
  
  <p>I would also like an error message to occur if someone else is currently in the file name "Pics &amp; Benefits upload file.xlsm" I.e. if another user is in the file it will exit the macro. (I'm not too sure how to do this)</p>
  
  <p>Thanks</p>