Parameterized Query

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

In an Enternal Data Call with a paramater, what is the
Excel function to display the value from the paramater?

Data/Import External Data and then use the paramater
options works well. I cannot find a means to display the
value the user typed into the prompted, paramaterized
query.
 
[This followup was posted to microsoft.public.excel.worksheet.functions
with an email copy to Chris.
Please use the newsgroup for further discussion.]

A couple of options come to mind to show the parameter value of a
query.

First, return the criterion/criteria field(s) as part of the query
result.

Second, use the variant of the parameterized query that looks up the
value in an XL cell.

--
Trouble finding replies to your posts? Use a newsreader. See the
tutorial 'Outlook Express and Newsgroups' on my web site

Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Back
Top