Avatar of Taras
Flag for Canada

asked on 

MS Access Docmd export to excel do not over write existing file

I ms access 2013 have a query that I want to export to folder and gave user option to locate folder and chose a name.
On a form I have command button and behind this code:
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12Xml, "Qry_My_Query", saveFileAs, True
Problem is when user what to use the same file name that exit.

I was prompted do I want to over wright file name I click on “Yes” button but it does not do over wright.
Microsoft Access

Avatar of undefined
Last Comment

8/22/2022 - Mon