Vba list all files in a folder in Excel
I want to run a macro to list the names of all files in a folder in a worksheet. I want the file names along with extensions. Please help
Use the VBA commande Application.Filesearch. See some good examples in the following link.
(for formulas, depending on your country, you might have to change ; with , or the opposite