VBA code to run a showcase query

[emre2548]

Here is what I wanna do;
I want to click on a command button on excel spreadsheet and it will run a showcase query and update the related pivot reports and charts in that workbook? I want to write a code behind the command button. Any help appreciated?

 

[xlbo]

Dunno anything about "showcase" but to refresh all pivottables in a workbook, use

for each ws in thisworkbook.worksheets
for each pt in ws.pivottables
pt.refreshtable
next
next

Rgds
Geoff
Si hoc legere scis, nimis eruditionis habes