Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula, automation turn red if value exceed a number | Excel Worksheet Functions | |||
Turn off getting started dialog | New Users to Excel | |||
how do I turn off the insert function dialog box in excel formulas | Excel Worksheet Functions | |||
Outlook Email Send Dialog Boxes, Excel 2003 How to Turn Off or Rem | Excel Discussion (Misc queries) | |||
Printing Text from Excel Automation | Excel Programming |