Automaticly print a word document??

[Junior1544]

What would be the easiest way of automaticly printing a msword document that is in the database as an ole object, without seeing the msword window, or if it has to come up for a minute, automaticly closing when it's done??

--Junior JHauge@jmjpc.net
Life is change. To deny change is to deny life.

 

[petersdaniel]

Junior, assuming that you are creating a Word Automation object within VBA, you can use the following method to render the Word application invisible while actions are performed

Dim WordObj As Word.Application
Dim WordDoc As Word.Document
Set WordObj = CreateObject("Word.Application&quot
Set WordDoc = WordObj.Documents.Open _
("your file path here&quot
WordObj.Visible = False 'This hides the app when is starts up
{what ever action you want on the document goes here}

WordObj.Quit
Set WordObj = Nothing 'kills the object instance