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!
Bookmarks