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
Unwanted message - Now outputing page
-
- Administrator
- Posts: 78647
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Unwanted message - Now outputing page
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.
Best wishes,
Hans
Hans
-
- StarLounger
- Posts: 56
- Joined: 24 Jan 2012, 21:48
Re: Unwanted message - Now outputing page
Thankyou Hans, I will have a look at your link. Have a good weekend