title: Save .xlsx files via excel vba, without opening saved file
body: <p>I'm making excel vba code that makes outlook message and attach excel file itself(xlsx) for the message</p>
  
  <p>below line is from my code.</p>
  
  <pre><code>ThisWorkbook.SaveAs ThisWorkbook.Path &amp; "\" &amp; Date &amp; " " &amp; "Position Report Ver.2.xlsx", FileFormat:=51 
  </code></pre>
  
  <p>This code saves xlsx file to specific folder.</p>
  
  <p>I want just saving copied xlsx file.</p>
  
  <p>but my code automatically opens saved file(xlsx file.) right after saving. and original file is closed.</p>
  
  <p>macro should run even after generating xlsx files because it should be attached to outlook message by vba macro.</p>
  
  <p>but, because xlsx file is opened right after saving, I can't run vba code after saving.</p>
  
  <p>How can I save from xlsm to xlsx without opening?</p>
  
  <p>I searched stackoverflow but I can't find the solution. code won't work or can't save to xlsx(just xlsm copy)... I couldn't find perfect answer...</p>