File name automatically changing in error when exporting from Access to Excel

[TaraC610]

Hello! I am receiving an error when exporting from Access to Excel. The query name is automatically being changed from the Access query name written in the docommand code to a string of letters and numbers in the file save location. The file won't save in Excel due to this. Any assistance is greatly appreciated!

[Luuk]

And how does your 'DoCmd' look like?

Or, otherwayz formulated:
This will always product a file named d:\temp\tabel1.xlsx, unless it already exists:

Function Macro1()
On Error GoTo Macro1_Err
    DoCmd.OutputTo acOutputTable, "Tabel1", "ExcelWorkbook(*.xlsx)", "d:\temp\tabel1.xlsx", False, "", , acExportQualityPrint
 
Macro1_Exit:
    Exit Function
 
Macro1_Err:
    MsgBox Error$
    Resume Macro1_Exit
 
End Function
 

[twinnyfo]

TaraC610,

Welcome to Bytes!

Yes, please post the code you are using and we can try to troubleshoot with yo.