title: Get Folder Path as String
body: <p>I'm relatively new with VBA and currently working on a macro that will change from PC to PC, for test purposes I'm using the direct path:</p>
  
  <pre><code>Sub VIP()
  
  'Define Folder Paths &amp; Workbooks
  
  Workbooks.Open ("C:\Users\j.lopez\Documents\AdHoc Reports\Serrano\Daily VIP Report Master.xlsx")
  </code></pre>
  
  <p>to open the workbooks, but eventually that path will change, so i was thinking to make the user select the folder path with:</p>
  
  <pre><code>Application.FileDialog(msoFileDialogFolderPicker)
  </code></pre>
  
  <p>But im lost, how can i properly:</p>
  
  <ul>
  <li>1.- Ask for a user to select the folder containing the necessary files for the macro to work with</li>
  <li>2.- Trap that path</li>
  <li>3.- Replace it in the WorkBooks.Open</li>
  </ul>