Question: can i import multiple text files into the same excel worksheet?
Answer: Import multiple text files as separate worksheets in Excel. Now you are all set to import files. Click on Macros again, and then Run . A window should pop up asking location of the text files.