UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Macro With Prompt?, Access 2016    
 
   
bakersburg9
post Oct 19 2017, 11:19 AM
Post#1



Posts: 4,952
Joined: 2-November 04
From: Downey, CA


I know you can save an import process in Access to import data from a worksheet tab and append the records to a table, but every time I do this, the filename I need to work with has a slightly different naming convention, like "DailyInvoice101717.xlsx" for Oct 17th, "Invoice101817.xlsx for the next day - is there a way to where it could prompt for the filename in the saved import?

Or, "Plan B," could a macro be created to accomplish all this? .... even if I had to go into the code an manually change the hard-coded filename, that would be preferable to doing this all manually...

Thanks in advance,

Steve
Go to the top of the page
 
theDBguy
post Oct 19 2017, 11:27 AM
Post#2


Access Wiki and Forums Moderator
Posts: 71,208
Joined: 19-June 07
From: SunnySandyEggo


Hi Steve,

Perhaps rather than saving the import process, you can save an import spec and then use macro steps to prompt for the filename and then execute a TransferSpreadsheet action using the saved import spec.

Just my 2 cents...

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Microsoft Access MVP | Access Website | Access Blog | Email
Go to the top of the page
 
bakersburg9
post Oct 19 2017, 12:04 PM
Post#3



Posts: 4,952
Joined: 2-November 04
From: Downey, CA


DbGuy,
Thanks! cool.gif I'll give that a try!
Go to the top of the page
 
theDBguy
post Oct 19 2017, 12:08 PM
Post#4


Access Wiki and Forums Moderator
Posts: 71,208
Joined: 19-June 07
From: SunnySandyEggo


You bet. Let us know how it goes.

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Microsoft Access MVP | Access Website | Access Blog | Email
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    12th December 2017 - 02:54 PM