Turn off printing status dialog with Excel automation

G

gm

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top