String together the first part of your directory as the
first argument in the method below:


Application.Dialogs(xlDialogOpen).Show ("c:\documents and
settings")


for you, it would be something like:

Application.Dialogs(xlDialogOpen).Show (myFlder & "NAME")

You could use a Select Case or If structure to assign
the "NAME" as a variable based upon the results of the
inputbox, if that's how your system works.