allow user to pick folder to run code on

[FROGGER24]

I would like some code that the default path is this:
\na.aaa.com\dfs\bbb\ccc\ddd\VPR\eee2011\eeee, and the user will be able to select the folder to run the code on. I will appreciate any help that is given

 

[VoG]

Maybe something like

With Application.FileDialog(msoFileDialogFolderPicker)
    .AllowMultiSelect = False
    .Show
    MyFolder = .SelectedItems(1)
End With