I have created a form that allows you to choose a word document to print. It then shells to word and a Macro prints the document and closes the application.

Is there anyway I can print the document without shelling out to Word.

As well is there a way I can select the printer to print too within that form (Combo box?). At the moment it prints to the default printer and I know that I can change the printer through the Word macro but this would require modifying the macro every time a new printer is added.


Thanks.




[LGuzman]

__________________
[LGuzman]

You can use Automation instead. In Access, set a reference to the Microsoft Word x.0 Object Library. Then place the following in your command button's click event:

Private Sub cmdPrintWordDoc_Click()

   ' SET REFERENCE: Microsoft Word x.0 Object Library

   Dim wordApp As Word.Application
   Dim wordDoc As Word.Document

   Set wordApp = CreateObject("Word.Application")
   Set wordDoc = wordApp.Documents.Open("C:\Test.doc")

   wordApp.Visible = False

   wordDoc.PrintOut Background:=False

   ' Quit Word.
   wordApp.Quit

   Set wordApp = Nothing
End Sub

When the file prints, you can invoke the MSWord Print File Dialog via VBA code in the Word document's code module. Open the Word document in Word and press F11 to open the VBA Editor. Add the following code:

Private Sub Document_Open()
    Dialogs(wdDialogFilePrint).Show
End Sub

The code in the Word VBA module will only execute when the Document object's PrintOut method is called from Access, i.e. the Print File Dialog won't show if you simply open the document in an instance of Word.

HTH,

Bob