Question: how to import multiple text files into multiple excel worksheets?
Answer: Import Multiple Text Files into Separate Worksheets Step2: open your excel workbook and then click on “Visual Basic” command under DEVELOPER Tab, or just press “ALT+F11” shortcut. Step3: then the “Visual Basic Editor” window will appear. Step4: click “Insert” ->”Module” to create a new module.