Macro to import Excel files

[John Hipskind]

I would like to create a macro to import Excel data into
my Access DB.

My Excel template is named "Cost Proposal." As new cost
proposals are generated, the template file is Saved As
CP_001, CP_002, etc.--these are the files I want to
import.

The TransferSpreadsheet action requires that the imported
file's name be specified in the action. However, since
the imported file names vary, I would like to specify the
file name "on the fly."

Is there a way to work with TransferSpreadsheet to do
this? Or do I need to go another direction?

(I use a named Range in the spreadsheet, and can import
the data just fine manually, but I'd like other users to
just click a button.)

Thanks for your help.

John