Question: how to open multiple text files in excel 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.