How to export pivot table from access to excel using vba code

P

Punki

Hi,
Can any one tell how can i export pivot table from access to excel using vba
code.

thanks
 
O

OfficeDev18 via AccessMonster.com

I don't know, but what I've done in the past was to export the data as a
table to Excel and make the pivot table in Excel. Excel has pivot-table-
making features beyond those of Access, and it seems easier also.

Hope this helps,

Sam
 
Top