Forum Discussion
Solved
Access VBA Syntax for Excel Output
Hi Guys I am trying to update an Access application. Currently there is VBA code included to output results in Excel format. The application is old so the output files produced are in an old Ex...
To export as .xlsx file use one of the following:
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12Xml, "exceltemp", "G:\DM_Report_Test\temp.xlsx"
OR
DoCmd.TransferSpreadsheet acExport, 10, "exceltemp", "G:\DM_Report_Test\temp.xlsx"
To export as .xlsx file use one of the following:
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12Xml, "exceltemp", "G:\DM_Report_Test\temp.xlsx"
OR
DoCmd.TransferSpreadsheet acExport, 10, "exceltemp", "G:\DM_Report_Test\temp.xlsx"
- You're welcome