ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   running Word/Excel in silent mode with Office XP PIAs (https://www.excelbanter.com/excel-programming/282506-re-running-word-excel-silent-mode-office-xp-pias.html)

Peter Torr \(MS\)

running Word/Excel in silent mode with Office XP PIAs
 
"Bob" wrote in message
...
Peter, setting DisplayAlerts on the Excel app object to false didn't do

the
trick.
Excel (with Visible set to false) still flashes the printing window (I

used
both _PrintOut and PrintOut methods), which disappears as soon as the
printing job get spooled.

In case of Word, all works fine (no pop-ups at all). Thanks.

Is there another special property of the Excel app object to suppress the
printing window?


Adding Excel group -- I don't know the answer I'm afraid.

Peter

--
Please post questions to the newsgroup - everyone benefits.
This post is provided "AS IS" with no warranties, and confers no rights
Sample code subject to http://www.microsoft.com/info/cpyright.htm
Bore yourself to tears -- http://blogs.gotdotnet.com/ptorr




All times are GMT +1. The time now is 07:34 PM.

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