Import Excel file different name each time

[osurfc]

I am trying to import an Excel file (different name each import). What I would like to do is in a combo/list box get a list of the excel files in a particular directory. Then select the specific excel file for import and run the import. The questions are how do I get the list of excel files? Do I write them to a table then select the file name from there? I am currently making a copy of the file and renaming it for import & then importing the data. Just looking for a simpler way to do this.

Thanks
Mark

 

[dinger2121]

Take a look at the MS Common dialog control - that might be what you are looking for.
Here are a couple of links to check out -

http://www.developerfusion.co.uk/show/11/

http://www.vb-helper.com/howto_select_file.html