title: Combine names of a Subfolder within a Subfolder to make a String
body: <p>I'm trying to get achieve creating a new <strong>string</strong> which is a combination of a <strong>folder path</strong> with a <strong>subfolder</strong> in VBA Excel 2007.</p>
  
  <p>Is there a way I can combine CurDir() with folder.path and path.separators which will give the result of a combined string?</p>
  
  <p>Example:</p>
  
  <pre><code>\\Tardis\Data\[PATH] = ParentPath
  \\Tardis\Data\[PATH]\HELLO = 1st Subfolder
  \\Tardis\Data\[PATH]\HELLO\WORLD = 2nd Subfolder
  </code></pre>
  
  <p>Result:
  HELLO WORLD</p>