View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JoeA2006 JoeA2006 is offline
external usenet poster
 
Posts: 7
Default Importing data from multiple Access queries

I am trying to import data into excel from Access from multiple queries based
on 2 parameters. I can create a macro to import the data, but I only want the
user to be prompted one time for the input, instead of a seperate prompt for
each query. Is there any way to use a input box to pass that input to each
query in MS query for instance?