title: Create a folder in any user's Desktop directory if it does not exist
body: <p>I have a file which, among other things, opens a specific folder when a button is pressed. I will be distributing this file to other users so the code must know to look at the correct directory to:</p>
  
  <ol>
  <li>See if the folder exists already or not, and if it exists open the folder</li>
  <li>Create the folder if it does not already exist, and open it after creating</li>
  </ol>
  
  <p>So far, here is the pertinent section of my code:</p>
  
  <pre><code>If Dir("C:\Users\myUsername\Desktop\sampleFolder", vbDirectory) = "" Then
            MkDir "C:\Users\myUsername\Desktop\sampleFolder"
            retVal = Shell("explorer.exe C:\Users\myUsername\Desktop\sampleFolder", vbNormalFocus)
       Else
            retVal = Shell("explorer.exe C:\Users\myUsername\Desktop\sampleFolder", vbNormalFocus)
  End If
  </code></pre>
  
  <p>My main issue is that I can't figure out how to get a user's actual username that would appear in the file path "C:\Users__________\Desktop"</p>
  
  <p>Is this even the right methodology? The code works if I insert my own username into the code, but I can't figure out the way to get the username automatically so the code is easy on the end user.</p>