Exporting Access Pivottable to Excel

A

Ad de Kruijff

I develop with Office XP Developer and we have Office XP
installed and Office 2000. I deploy Runtime versions of
my application.

The problem is with Office 2000, Office XP works
allright. When I have a query viewed as a Pivottable, I
want to be able to export to Excel, but this seems
impossible.
I tried several options after the command:
DoCmd.SelectObject acQuery, "Pivotquery", False
Such as ctrl-a; ctrl-c, then opening a Worksheet and ctrl-
v (in VBA). This creates an empty sheet, except when
there is some other info on the clipboard, then this is
copied.
DoCmd.OutputTo en DoCmd.TransferSpreadsheet transporteren
wel de query-data, maar niet als Pivotview.
En DoCmd.RunCommand acCmdPivotTableExportToExcel geeft
als melding "The command is not available now".

Is there a solution for this?????????
 

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

Similar Threads

Exporting to Excel 2003 from Access 2000 1
Export to Excel 97-2003 not allowed 2
export to excel from access 2
Exporting Access Data to Excel and keeping format 2
Advice on Exporting to Excel from Access 1
Pivottable linked to Access problems 1
Fixed length when exporting to Excel 3
Problem in exporting the access 2007 report to excel 3

Top