Exporting Excel Files from Access 2007 Using Macros/VBA
I have some VBA code in an Access 2007 database that exports data to an Excel file (.xlsx extension) using the TransferSpreadsheet command.
I have noticed that with all files created by this process, if someone is to open the file and edit it, a "backup" of the file is automatically created (with the name "Backup of filename.xlk"). I really don't want these backups out there mucking up our folders.
Is there some way to prevent Access from creating the files this way? It does not appear to be any argument in the TransferSpreadsheet command.
Using Access 2007
Proficient in Access, Excel, VBA, and SQL