Automating an Access Pivot table export to Excel with VBA (2003)

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
 
G

Guest

I'm not sure about the first problem but for the second the only way that I
found that it could be handled was to write a macro that opens the form in
pivot table view and have your switchboard use that macro. I hope this helps.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top