title: VBA for MS Access: write to an excel file without opening, write to last row, save and close
body: <p>I am using VBA in MS Access for the first time and cannot get the following right:
  <strong>Launch an excel file</strong> (without actually opening the file), then <strong>write to the last row</strong> in the excel file, and then <strong>save</strong> the file (with the same path and name as before, essentially replace the previous file), then <strong>close</strong> the excel file.</p>
  
  <p>Please assist! So far I can write to an excel file, but cannot save and close without closing the whole MS Access application.
  If you could please give a sample of working code to do the above, I will tailor it for my requirements.</p>
  
  <p>Thanks!
  Christine</p>