Excel Format

[Thompyt]

How can I get access to output my reports in an XLSX vs an XLS format?



DoCmd.OutputTo 3, "Report_Name", acFormatXLS, "C:\Temp\Report_Output_Name - " & Format(Date, "dd mmm yyyy") & ".xls", , 0

I have tried
acFormatXLSX and & ".xlsx", , 0

DoCmd.OutputTo acOutputReport, "Report_Name", acFormatXLSX, "C:\Temp\Report_Output_Name.xlsx", True

I get - Runtime error '2282': "The format in which you are attempting to output the current object is not available."

I don't want an Excel 95 workbook.

Thanks

[CJ_London]

not sure you can output a report to excel as indicated by the error message - potentially too many formatting issues. As an experiment, try outputting to a .pdf instead. Also try outputting a table to excel - if both work then think exporting a report to excel is a no no.

[Thompyt]

Ajax - I don't have any issues with .pdf. Just the excel. It is outputted in the WIN95 version when using .xls and is not saveable by the recipient after they make changes on thier systems. .xlsx does work.

[Micron]

This may not be your issue, but it indicates you can (or at least, could) output a report to Excel

https://support.microsoft.com/en-gb/kb/934833

[cyanidem]

Instead of:
acFormatXLSX
try:
acSpreadsheetTypeExcel12XML
or simply:
10
Those both should export to .xlsx format (Excel 2010)