Turn on Macro recorder while performing the operation. Then post the code
and I will make the changes to select a file name.

"Memphis" wrote:

Hello Everyone,
I am currently importing data into an excel sheet from an Access query.
I go to Data/ Import External Data/ Import data, and on the Select Data
Source I find the Shared Drive (S:\) and then find the folder where the .mdb
is found.
Now every month the path is the same, only the name of the .mdb file changes
its, basically I get a new batch of information for the new month.
What I want to look into is the possibility of creating a Macros that promps
the user for the file name they need to import the data from and have the
system do the importing for them and drop the imported data beginning with
Cell A1.
The Command button for this operation is not in the actual sheet were the
imported data is going, it is in a sheet I call €œCase Control€�, the data
needs to be propagated to the €œImpData€� sheet.

Thank you.