Simple export to excel

[#1]

I have not tried using the buttons with action items before so I tried exporting a pivot table to excel.

I created the attached test. When I press the XL in the caption it exports the table with the four expressions. However, when I use the button the file I get only shows the field the expression is based on not the four expressions.

Am I doing something wrong. How do I get round this so I can have a button that exports the table as I see it in qlikview.

Thanks

[#2]

I used some code posted by FAA under the post

How do I create a VBscript to export data from a sheetobject to .CSV file

and it works.