title: Excel VBA to save to specific folder (with current code generating filename)
body: <p>workers,</p>
  
  <p>I have this code at the moment;</p>
  
  <pre><code>Public Sub SaveAsA1()
      ActiveWorkbook.SaveAs Filename:=Range("P4").Value &amp; ";" &amp; Range("F6").Value &amp; ";" &amp; Range("R6").Value &amp; ";" &amp; Range("R4").Value
  End Sub
  </code></pre>
  
  <p>Which i would like to modify to be saved in a certain filemap; \S31000265\Users$\NR4236\My Documents\TV-01-project\TestmapWeek9GOED. Been trying but it keeps overwriting the Filename-code. Hope you guys can help me out.</p>