Importing a data from a text file - user-defined file

Hey all,

I need to make a macro that imports text data from a file in a user-defined directory.

The data will always be from a different directory but will always be in the same format. The data is a text file that we've changed the extension to for other purposes, something like .datatxt.

What I would like to do is have the user enter in the correct directory, push a button, and the script pulls the data in from the proper file in that directory.

The data files will be something like

Q:\.........\Results\Test#_####.output.datatxt

and it will be the only file in the directory with the Results\.....output.datatxt name. So I have no problem getting the full file name using some concatenate/len/right functions once the user inputs the directory.

Just need to know how to make the script search for that file.

Thanks!