VBA - HOW TO: Populate a LISTBOX with documents from a Directory
Real simple,
Populate a Listbox with excel files from a directory for easy file management, then open.
Also note that rather than hard coding a directory location to pull files you can use Application.FileDialog msoFileDialogFolderPicker to select the folder and thus all the excel files in that folder