etpeterson
New Member
- Joined
- Jan 19, 2005
- Messages
- 18
I currently have a spreadsheet that takes a folder location from the use that is entered into a cell and opens 10 files in that folder, 1.txt-10.txt and makes seperate worksheets out of each of them. I recorded this macro and excel looks for an exact file name match. I would like to change this so excel will open any .txt file in the specified folder and create a worksheet for each file. Please Help!
Thanks,
Eric
Thanks,
Eric