title: VBA - change directory folder with a cells value name
body: <p>I made a worksheet with some buttons to save, save as and print quickly, but when a I Save As is saving on the Google Drive folder because is where the current file is, but i want to save on desktop and I can't find a way to make this change directory without break the name of the file. I make the file auto rename to a value of two cells (B10 and B15) when Save As, but when i make the directory change with some ways I found on the internet, doesn't work. I cant make the name and the directory right without a error.</p>
  <p>My current code:</p>
  <pre><code>Sub SaveAs()
  On Error GoTo ErrorSaveAs
  
  Dim ClientName
  
  ClientName = Range(&quot;B10&quot;).Value &amp; &quot; - &quot; &amp; Range(&quot;B15&quot;).Value
  
  ActiveWorkbook.SaveAs FileName:=&quot;ClientName&quot;, FileFormat:=xlOpenXMLWorkbookMacroEnabled
  
  MsgBox &quot;O arquivo foi salvo no seu Desktop.&quot;, vbVertical, &quot;Sucesso! - Garage Audax&quot; 'Success message after saving it
      
  Exit Sub
  
  ErrorSaveAs: MsgBox &quot;Ocorreu um erro. Revise as informações e tente novamente.&quot;, vbVertical, &quot;Ops! - Garage Audax&quot; 'Error message in case of any error
  
  End Sub
  </code></pre>