running Word/Excel in silent mode with Office XP PIAs

  • Thread starter Thread starter Bob
  • Start date Start date
B

Bob

Hi,

I am using Office XP PIAs. I want to use Word/Excel to printOut documents
w/o bringing up the application at all.
When I set the Visible field to false, I still get the printing window
appear for a little while.
Is that possible to run these applications with no windows popping up at
all?

I print out a document as follows
object myFalse = false;
object missing = Type.Missing;
aDocument.PrintOut(ref missing,ref missing,ref missing,ref missing,ref
missing,ref missing,ref missing,
ref missing,ref missing,ref missing,ref myFalse,ref myFalse,ref
missing,ref missing,
ref missing,ref missing,ref missing,ref missing);

Any help is greatly appreciated.

Thanks,
Bob
 
Bob said:
I am using Office XP PIAs. I want to use Word/Excel to printOut documents
w/o bringing up the application at all.
When I set the Visible field to false, I still get the printing window
appear for a little while.
Is that possible to run these applications with no windows popping up at
all?
Click to expand...

Hi,

Have you also tried making DisplayAlerts false?

Peter
 
Peter Torr (MS) said:
Hi,

Have you also tried making DisplayAlerts false?

Peter
Click to expand...
Hi,

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?

Thanks,
Bob
 
Bob said:
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?
Click to expand...

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

Peter
 
Back
Top