This might be what you are looking for:

Sub dk()

Wb = Application.Dialogs(xlDialogOpen).Show
MsgBox ActiveWorkbook.Name
End Sub

You can use the "previous" icon in the dialog box to walk back up the
directory chain.

"Diana" wrote in message
...
I want users to be able to specify the directory where their files are
located. I manipulate a number of files, one person might have them under
c:\mydata, another might store them f:\test. Is there such a control in
Excel? Thanks in advance.