1.) How to refresh a single query on button click? I don't want to refresh all queries in my workbook.
2.) How to set a filter value on button click? But not allways the same value. The value changes depending on the selected range in the workbook. for example: onbutton-click--> filtervalue = activesheet.selection AND single query refresh
(Bex Analyzer 7)
Thanks for your help in advance!!!!!