Passing parameters from excel sheet to microsoft query?

  • Thread starter Thread starter Eleanor
  • Start date Start date
E

Eleanor

My goal is to Open up The Excel Sheet ask for parameters,
and pass those parms to Microsoft Query , and then return
daa to Excel.

How do I do this?


Thank you,
Eleanor
 
My goal is to Open up The Excel Sheet ask for parameters,
and pass those parms to Microsoft Query , and then return
daa to Excel.
Click to expand...

I've never used Query, but I'd bet that it can be done using Visual Basic.
Certainly you'll have to use a programming language if you want to pop up a
dialog box and ask for parameters.
 
Back
Top