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

--
bcha
-----------------------------------------------------------------------
bchan's Profile: http://www.excelforum.com/member.php...nfo&userid=827
View this thread: http://www.excelforum.com/showthread.php?threadid=27008