Export / copy Access Pivot Table View to Excel 2003?
Is there a way to copy an Access 2003 pivot table view (used to pivot 206,000 record开发者_如何学编程s) to Excel 2003 using VBA?
Not sure if number of records matters unless the result exceeds Excel 2003 column and/or row max.
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel11, "qryPivot_Table_Name", "C:\Users\user\Documents\PivotTable.xlsx", True
How about this?
DoCmd.OpenQuery "qryPivot_Table_Name", acViewPivotTable
DoCmd.RunCommand AcCommand.acCmdPivotTableExportToExcel
after that you just need to get a reference to the new workboook through Excel.Application object
If all you need is a visible display of the data, such as the totals, Ctrl+C the selected range you want to show, then Shift+Edit+Paste Picture Link. When data is updated it will change the image. I would think you can adapt this to a macro, and generate what you want to distribute, fairly easily.
精彩评论