etpeterson
New Member
- Joined
- Jan 19, 2005
- Messages
- 18
My current spreadsheet takes a file path that the user inputs into a cell, ex.(D:\test_log\01-19-2005) into cell "B5." In that folder are numerous text files. I currently have the spreadsheet open 1.txt-10.txt in the folder specified by the user, after they push I button I have linked to my macro. What I would like to do is have the user push the button and a dialog box come up asking the user where to look for the .txt files. I don't want them to have to type in the path, but just "browse" through their file structure and click on a folder. The variable that this dialog box saves the information to needs to be compatible with this line:
Workbooks.OpenText Filename:=Range("B5") & "\1.txt"
Where Range("B5") is the name of the folder. (This is the old way I was doing it.)
I hope I gave enough information for someone to understand what I'm doing and is able to help.
Thanks so much!!!
Eric
Workbooks.OpenText Filename:=Range("B5") & "\1.txt"
Where Range("B5") is the name of the folder. (This is the old way I was doing it.)
I hope I gave enough information for someone to understand what I'm doing and is able to help.
Thanks so much!!!
Eric