I'm having an issue overwriting to an existing EXCEL file. Here's the code:
ofile = "\\corpshare\corp\Rev_Cycle_QA_Reports\Shared\NPI\ Daily\Daily Results.xlsx"
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12Xml, "t10_NPI_Import", ofile, True
The file is not being overwritten nor does the date modified change to the existing file with the extension .xlsx.
However, when I change the extension from .xlsx to an existing file with the extension .xlsb, the file does get overwritten and modified date is updated.
I know my 1 option is to KILL the .xlsx before exporting, but can someone explain why .xlsb works and .xlsx doesn't work? I need the extension to be .xlsx because it's being imported into PowerBI.