Export Access Query Results to Excel and open the workbook

[mykal66]

Good morning

A button on my database runs a query and saves the results to an Excel workbook. Does anyone know how to alter this code to automatically open the workbook after it is saved please?


DoCmd.OpenQuery "qryData", acViewNormal, acEdit
DoCmd.OutputTo acOutputQuery, "qryData", acFormatXLSX

Thank you

Mykal

[OBP]

Workbooks.Open FileName:=(Path & docName)
Where Path is the path to the folder and dconame is the name of the excel document.

[Kenneth Hobs]

More of an Access question but the answer is simple.

'https://docs.microsoft.com/en-us/office/vba/api/access.docmd.outputto
DoCmd.OutputTo acOutputQuery, "qryData", acFormatXLSX, , True