Question: how to copy folder names into excel vba?
Answer: Open the workbook that you need to input the file names. And then press the shortcut keys “Alt +F11” on the keyboard to open the Visual Basic editor. After that, click the tab “Insert” in the toolbar.