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