Question: how to import multiple files in excel vba?
Answer: Hold down the ALT + F11 keys in Excel to open the Microsoft Visual Basic for Applications window.
Click Insert > Module, and paste the following code in the Module Window.