If you are using QV11, both Straight Table and Pivot Table can be configured to hide columns. If u want to hide a dimension, go to Chart Properties > Dimensions > Select the Dimension u want to hide > Enable Conditional > Insert the condition.
If u are using QV10 or previous, only the Straight Table can be configured to hide columns. Go to Chart Properties > Presentation > Select the Column u want to hide > Conditional > Insert the condition.
The Table Box object cannot be configured to hide columns.
If u opt for the 'button to export' approach, the macro code is:
set obj = ActiveDocument.GetSheetObject("CH01")
Hope this points u to the right direction.