Question: how to import multiple text files into one excel spreadsheet vba?
Answer: 1. Enable a workbook you want to import text files, and press Alt + F11 keys to enable Microsoft Visual Basic for Applications window. 2. Click Insert > Module, copy and paste below VBA code to the Module window.