Hi all,
I have a file path i wish to save to within my VBA code however part of the file path needs to be selected depending what what you are working on
For Example my file path would be:
C:\Users\simon.ward\Desktop\Stores\2013\Sept\Mansfield\Reports
The Year and Month i can pre-set as variables so no problem there but the Region (ie Mansfield) is a variable which i need to select because within the "Sept" folder there will be many region names which i need to choose from, each of which having a "Reports" folder within.
I was hoping that Excel could be good enough to pop up a Dialog box which lists the Region folders for the user select which will set the variable within the code
Hope that all makes sense
Many Thanks in advance
Simon
Bookmarks