I'm getting the below error message when I try to open an Excel 2007 workbook (.xlsx) that was created during an export from Access 2007 (see code below).
I've seen similar posts, but my issue still persists even when I try using one of these:
It will work for .xls files using acSpreadsheetTypeExcel9, but I can't get it to work for .xlsx files. Any help is greatly appreciated.
exportPath = "C:\ExportPriorities\"
fileName = "Technology Request Prioritization List as of " & Format(Date, "YYYY_MM_DD") & ".xlsx"
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12, "QS-New", exportPath & fileName, True