Macro Prompts

  • Thread starter Thread starter Andrew
  • Start date Start date
A

Andrew

Is it possible to have a macro prompt for a databse
object, such as what query or table to use? As an
example, if I want the same macro to run using a
different table or query each time the macro is run, can
I write the macro to prompt me for what table or query to
use? A lot of the macro arguments "require" a table or
query name but I would like to type a different tabel or
query name as I see fit.
Thanks.

Andrew
 
try this where the table name is in the macro
=InputBox("Enter the name of the table to be opened:")

Jim
 
Back
Top