Hi all,
I want to import all files from a directory that I choose, to Excel. How can I define which files (in this case all files) in a directory, eventually by using a listbox?
Regards,
sveegaard
Printable View
Hi all,
I want to import all files from a directory that I choose, to Excel. How can I define which files (in this case all files) in a directory, eventually by using a listbox?
Regards,
sveegaard
Search the VBA help for the DIR function. It has lots of examples of looping through the files in a directory.