Opening a Dialog Box for Folder Selection

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

You may use:

Please Login or Register  to view this content.

Simply pass the initial file path to the function.

NOT MY CODE, but a quick google finds this, which seems to do exactly what you want:

http://www.your-save-time-and-improv...ct-folder.html

You may use:

Please Login or Register  to view this content.

Wherever in your code you wish to retrieve the folder path.

I do not know what your code is, so I cannot tell you where to put this. If you will post your code, I will show it.

Dialog returns -1 if Ok is pressed. If you wish to show message if user does not choose a folder, you may test for result of GetFolder being equal to "".