Hello,

This may be kind of difficult to code. I'm looking for a UserForm that has a list of all the currently open excel files. I want to allow the user to select one of the files in that list and then once that file is selected, import data from that file.

I know how to import data from a file, just not how to create the UserForm part. The reason I want to use a UserForm is because the name of the input file changes every day, and there is not pattern in naming convention I can take advantage of. Unless there's another better method, this is what I thought of.

Thanks!