G
Guest
Hello all,
I have created a Pivot table in Access. Of course this is actually a "Form"
rather than a table (however in the Title Bar it references the query it is
fed from).
Problem 1: There is a nifty little button at the top of the window in the
Pivot Table Tool bar called "Export to Microsoft Office Excel". I want to
write a script in vba that I can reference from the switchboard that will
automatically export the pivot table to Excel for me.
Problem 2: I am also having a problem viewing my Pivot table from the
switchboard. When I assign the object a button with the "Open Form" selected
it opens it as a true form and not a Pivot Table.
Any help out there?
Thanks,
Patrick
I have created a Pivot table in Access. Of course this is actually a "Form"
rather than a table (however in the Title Bar it references the query it is
fed from).
Problem 1: There is a nifty little button at the top of the window in the
Pivot Table Tool bar called "Export to Microsoft Office Excel". I want to
write a script in vba that I can reference from the switchboard that will
automatically export the pivot table to Excel for me.
Problem 2: I am also having a problem viewing my Pivot table from the
switchboard. When I assign the object a button with the "Open Form" selected
it opens it as a true form and not a Pivot Table.
Any help out there?
Thanks,
Patrick