I have a certain excel spreadsheet which I would like my users to download. The only catch is that the location of this spreadsheet is variable, and I would like to have the users browse for it.

I do not want them going into import manually, and I would like to have the table permanently named no matter the name of the spreadshet. The first row DOES contain the column names, and there are no keys.

Is there a vba way to do this?