M
MCyn
I am currently working with Access97. I wonder if anyone could help me how to
create a pivot table using VBA code. The data would come from a table being
exported to Excel. (ex. I have a table in my database called "PivotTestTable"
and it's being exported to Excel) What code (if any) would I write to use
this currently exported table to excel and create a pivot table. Any ideas? I
was looking into the .PIVOTTABLEWIZARD function in access, is this a lead?
create a pivot table using VBA code. The data would come from a table being
exported to Excel. (ex. I have a table in my database called "PivotTestTable"
and it's being exported to Excel) What code (if any) would I write to use
this currently exported table to excel and create a pivot table. Any ideas? I
was looking into the .PIVOTTABLEWIZARD function in access, is this a lead?