Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Marty Jackson   on Nov 06 In MS Office Category.

  
Question Answered By: Sally Pierce   on Nov 06

I tried this:
Sub Print_Test()
Dim ExecStr, wrd, WordFileName
WordFileName = "C:\temp\SampleWordFile.doc"
ExecStr = """C:\Program Files\Microsoft Office\OFFICE11\WINWORD.EXE""" &
WordFileName & " /x /n /dde"
WID = Shell(ExecStr, 1)
Set wrd = GetObject(, "Word.Application")
wrd.PrintOut
wrd.Documents.Close
wrd.Quit
End Sub

Share: 

 
 
Didn't find what you were looking for? Find more on Printing Word Docs from Excel Spread Sheet Or get search suggestion and latest updates.


Tagged: