How do you load all the files in a folder for a user to select

[TrailblazerLS]

I would like to load a directory containing all the excel files and have the user be able to select the appropriate file and click on it to open....
Is there an easy way to accomplish this? OR a sample piece of code to do this task.

 

[Remou]

There are a number of posts in the Access fora with keywords "allow user select file". Here is one such post:
IMPORT Excel Sheet into Access allowing user to select file
thread705-760625

Different methods can be used in different versions of Access.