Hi, I've been searching for websites which give some ideas on how to create pivot table and export it to Excel by using VBA. Can anybody give me reference where I can find the tutorial or guideline? Thanks.
If export = False Then
DoCmd.OpenQuery "TempQry", acViewNormal, acReadOnly
Else
FileName = "test"
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel8, "TempQry", FileName
End If
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.