title: "SaveAS" macro in excel with password protection
body: <p>Hi I have this macro in excel file:</p>
  
  <pre><code>ActiveWorkbook.SaveAs filename:="C:\SAP Imports\Sales Orders\" &amp; Range("A1") &amp; ".xlsm", FileFormat:= _
          xlNormal, Password:="", WriteResPassword:="", ReadOnlyRecommended:=False _
          , CreateBackup:=False
  </code></pre>
  
  <p>This macro is password protected. Whenevr I run this I get "run time" error and I am not able to figure out whats wrong with my code.</p>
  
  <p>Should I write my password instead of writing "". Please advise.</p>