title: excel saving with VBA issues and ways around it
body: <p>I have a relatively involved sub that transfers a bunch of data around within a workbook in excel and does a handful of other things, then saves the file at the end of the sub using <code>activeWorkbook.save</code></p>
  
  <p>however for reasons unknown to me, when the file has been open for a long time and I save it gives me a message saying the file has been edited by another user and prompts me to either notify the other user and not save or overwrite any changes made by the other user. Is there a way to code the sub to make it overwrite no matter what, so that if that dialog box comes up, it doesn't prevent the sub from running?</p>
  
  <p>Also, there is no one else editing the file so i don't know why its giving me the message in the first place, i just want it to bypass that if it happens to come up.</p>
  
  <p>Thanks for the help!</p>