Passing parameters from excel sheet to microsoft query?

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
 
J

Jonathan Rynd

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.
 
Top