title: How to save to current User\Desktop location
body: <p>So I am trying to save an excel worksheet as a .PRN file to the current users desktop. I thought maybe there was a standard "wildcard" operator that I could use, but I don't see that anywhere. I have looked through stack overflow and I found information that is probably what I am looking for, but due to me not being a programmer and not very good with excel, I don't know if it is what I want and if it is, where to put it in my code. </p>
  
  <p>This is what I am currently running that only works on my machine:</p>
  
  <pre><code>Sub Save_PRN()
  Dim fileName As String
  fileName = "C:\Users\cameron\Desktop\PRN Test files\" &amp; Range("'Customer_Info'!R2").Text &amp; ".prn"
  ActiveWorkbook.SaveAs fileName:=fileName, FileFormat:=xlTextPrinter, Password:="", WriteResPassword:="", ReadOnlyRecommended:=False, CreateBackup:=False
  End Sub
  </code></pre>
  
  <p>While it does what I want, when I upload it to our share, clearly another user won't be able to use it. I saw on a question someone answered stating to use this:</p>
  
  <pre><code>MsgBox CreateObject("WScript.Shell").specialfolders("Desktop")
  </code></pre>
  
  <p>But I don't know or understand how to incorporate that into my macro above. Any help or advice would be great. Am I even on the right track?</p>