Unwanted message - Now outputing page

[spectrum]

I have code to export an Access report to Excel.It puts up a dialogue box saying it's outputing page number ..... Is there a way to stop showing this? Thanks

DoCmd.OutputTo acOutputReport, "QueryForm2", acFormatXLS, stFileName, True, "", , acExportQualityPrint

[HansV]

As far as I know, there is no way to suppress that message entirely. You can use the code from API: Suppress the "Printing" Dialog to minimize the dialog. You'll have to try it yourself to see whether that is an improvement.

[spectrum]

Thankyou Hans, I will have a look at your link. Have a good weekend