J
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
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