How would I create a loop with Microsoft Visual Basic to import multiple .txt files into excel; creating a seperate worksheet for each .txt file and nameing the worksheet based on the filename? I have hundreds of these .txt files. I would also like to be able to import more of these .txt files into the same workbook in the future.
Thank You
Bookmarks