Overwite to exported Excel

**Dave_D** · 02-22-2024, 02:32 PM

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.

**pbaldy** · 02-22-2024, 04:20 PM

Since nobody has answered, I'll offer a couple of thoughts. First, acSpreadsheetTypeExcel12Xml seems an odd option, but may not be a problem.

This is more of a workaround than an answer, but I do all kinds of automated exports that will replace an existing file and I generally use OutputTo without issue.