MS export, cannot find file

[mayhem11]

I am trying to export a query to .xlsx and I have the file in mydocuments and I get cannot find file error. Do I need to not name the file and just allow the end-user to select the file name instead?

Here is my code:

Private Sub cmdExcel_Click()
DoCmd.OutputTo acOutputQuery, "qryA", acFormatXLSX, "C:\qryA.xlsx", , , , acExportQualityPrint
End Sub

Maybe I should be doing this?

Private Sub cmdExcel_Click()
DoCmd.OutputTo acOutputQuery, "qryA", acFormatXLSX, "C:\.xlsx", , , , acExportQualityPrint
End Sub

 

[Andrzejek]

You say: "I have the file in mydocuments " yet you look for "[tt]C:\qryA.xlsx[/tt]"

So, where is the file you want to use?
Do you have a file named [tt]qryA.xlsx[/tt] straigh on your [tt]C:\[/tt] drive?

Have fun.

---- Andy

A bus station is where a bus stops. A train station is where a train stops. On my desk, I have a work station.