Try changing "ExcelWorkbook(*.xlsx)" to acFormatXLS
DoCmd.OutputTo acOutputServerView, "dbo.Issue Open 3", acFormatXLS, "I:\Groups\ccuser\Finance\Collection Control\Open Issues\OpenIssuesReport.xls", False, "", , acExportQualityPrint
Try changing "ExcelWorkbook(*.xlsx)" to acFormatXLS
DoCmd.OutputTo acOutputServerView, "dbo.Issue Open 3", acFormatXLS, "I:\Groups\ccuser\Finance\Collection Control\Open Issues\OpenIssuesReport.xls", False, "", , acExportQualityPrint
Boyd Trimmell aka HiTechCoach
Microsoft Access MVP -2010-2015
Programming: Nine different ways to do it right, a thousand ways to do it wrong.
Binary--it's as easy as 1-10-11
Posting Permissions
Reply With Quote