title: Visual Basic in Word 2010 - Open Dir - Relative Path
body: <p>I'm creating a word document and I'm having trouble working out the code to open a specific directory.
  Basically, I'll have a bunch of video files on a USB drive or a DVD in separate folders and when the command button is clicked, I would like it to open the relevant directory in a windows explorer window.</p>
  
  <p>I did some Google searching and came up with the following code:</p>
  
  <p>FolderName =  "c:\windows" </p>
  
  <p>TaskID = Shell("explorer.exe " &amp; FolderName, vbNormalFocus)</p>
  
  <p>The only problem now is that I need to change the path reference from absolute to relative, as I'll be running everything from either a USB drive or a DVD on multiple computers.</p>
  
  <p>I have tried every possible iteration of relative path references, but I can't seem to get it to work. The folders are simply sub-directories of where the word document is.</p>
  
  <p>Anyone got any clues as how I can change the above code to be relative rather than absolute path references?</p>