use the common dialog box control, or build a control of your own using
list boxes, or (more simply) invoke the File Open command from VBA but
just use this to get the file name - this example will get a text file,
but can be adapted to pick up any file of the users choice

FileToOpen = Application.GetOpenFilename("Text Files (*.txt), *.txt")