Hi,
I have Report dialog box form where we could choose multiple reports to preview or print. I created a Pivot table report it looks great when Preview but in the option to print I would like for the file to be transfer to excel in Pivot Table format. I got the file to transfer but it does it in spreadsheet mode not Pivot Table. Any ideas...Thank you
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel8, "P_Visits&PaymentsSummary", "\\JMCNAS02\OncologyRIE$\Summary Report of all Paid and Unpaid Claims" & Format(Date, "DD/mm/yyyy")
I have Report dialog box form where we could choose multiple reports to preview or print. I created a Pivot table report it looks great when Preview but in the option to print I would like for the file to be transfer to excel in Pivot Table format. I got the file to transfer but it does it in spreadsheet mode not Pivot Table. Any ideas...Thank you
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel8, "P_Visits&PaymentsSummary", "\\JMCNAS02\OncologyRIE$\Summary Report of all Paid and Unpaid Claims" & Format(Date, "DD/mm/yyyy")
