ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Turn off printing status dialog with Excel automation (https://www.excelbanter.com/excel-programming/325856-turn-off-printing-status-dialog-excel-automation.html)

GM

Turn off printing status dialog with Excel automation
 
Does anyone know how to turn off the printing status dialog, which is
displayed when printing a sheet with excel via automation?

By using this code, there is always displayed a print status dialog, while
excel is printing the document.

app.CreateDispatch("Excel.Application");
app.SetVisible(FALSE);
app.SetDisplayAlerts(FALSE);

workbooks = app.GetWorkbooks();
workbook = workbooks.Open(.....);
workbook.PrintOut(vOpt, vOpt, vOpt, vOpt, cstrPrinter, vOpt, vOpt);

Thanks for help
gm



All times are GMT +1. The time now is 03:05 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com