I am trying to find a way that allows a user to select a default folder to save files to.

ex.

Joe wants to save his files (via a macro that sets custom property values) to C:\ProjectXYZ

Jane wants to save her files to C:\Project Z

What VB code brings up a folder dialog box and allows them to select a folder?  I thought about getting the value of the folder they selected than storing it in a excel spreadsheet.  The next time the user runs the macro, he/she has a default folder to save to OR they can click a button to change the default location (the default location could change daily).