title: VBA EXCEL To Prompt User Response to Select Folder and Return the Path as String Variable
body: <p>I am trying to write a VBA code where a dialog box would appear for the user to select where they want to save the files.
  However, I just need the path value (e.g. <code>c:\Desktop\Values</code>) returned as a string variable so that I could use it in another function. 
  Any help would be appreciated.</p>