MrExcel Publishing
Your One Stop for Excel Tips & Solutions

How can I print a word document in middle of excel macro?


Posted by Jason Kraft on August 26, 1999 12:11 PM

I've searched and searched for a way to print a particular MS word document in the middle of my excel macro. Is this possible?


Posted by Ivan Moala on September 19, 1999 4:57 AM

Jason,
try this;
Sub PrintWordDoc()
Dim AppWord As Word.Application
Set AppWord = GetObject("C:\windows\mydoc.doc")
With AppWord
.ActiveDocument.PrintOut Background:=False
.Quit SaveChanges:=False 'Quit & close without changes
End With
Set appWord = Nothing 'release reference to it
End Sub

Ivan