Macro for Parameter Query

[bchan]

When writing a macro for a parameter query in Excel pivot table, I ca
do this: *“WHERE field = ?” * and I am given a promp
“-Parameter 1-” before running the pivot. I would like t
customize the prompt but have not been successful. I trie
“*WHERE field = [Give Branch Name]*” which works with M
Query but not in VBA. Alternatively, there is a PromptString propert
in VB but it works only for QueryTable (Parameters is not a member o
PivotTable). How do I change the default prompt to something mor
instructive

 

[arno]

Hi,

I think, there's no popup function in Excel for parameters. Have the
user enter parameters into normal inputboxes with VBA, then construct
the query with this data and fire the query (instead of having the
query to prompt for input).

arno