List of files in folder

[toocold]

Good afternoon all,

I have a folder that has a lot of documents in it. I also have an excel file that lists all the documents and the file paths. Basically an index that allows a user to select a document from a listbox and open it.

What I want to do is automate the updating of this list. I want to have a button that I will press, on a userform, that will then compare the files in the folder to the list in my spreadsheet. Any new files will be added to a listbox for the user to select and provide additional details.

What I am not sure is how to grab the file name of the files in the folder without opening the open dialog box. Ideas?

Thank you in advance!!!
dw

[mrice]

Have a look at the download on my home page for a macro which lists file names in a folder (and sub folders).

[ska67can]

Assumes your file list is in Column A

Please Login or Register  to view this content.

ska

[toocold]

Thanks guys! Exactly what I needed to get this working!
dw