title: FileSystemObject.CreateFolder to create directory and subdirectories
body: <p>I would like to create a directory and a subdirectory with the following code:</p>
  
  <pre><code>Public fso As Scripting.FileSystemObject
  Set fso = New Scripting.FileSystemObject
  fso.CreateFolder ("C:\Users\&lt;my_username&gt;\DataEntry\logs")
  </code></pre>
  
  <p>I am trying to create nested directories. In this case, the <code>DataEntry</code> directory would not exist, so essentially I would like to create 2 directories, <code>DataEntry\logs</code> under <code>C:\Users\&lt;username&gt;</code></p>
  
  <p>If I enter command prompt, I can create that directory with <code>mkdir</code> without any issues. However, I simply cannot get VBA to create that folder and I get:</p>
  
  <pre><code>Run-time error '76':
  
  Path not found                        
  </code></pre>
  
  <p>I am using Excel VBA 2007/2010                  </p>