Question: how to import multiple file names into excel?
Answer: Launch a new worksheet that you want to import the file names.
Hold down the ALT + F11 keys to open the Microsoft Visual Basic for Applications window.
Click Insert > Module, and paste the following code in the Module Window.