Print word document from excel

[littleguy1810]

Hi

A great guy has been helping me with this code(Macropod) could someone help me with this as he is offline, ?I get an error msg when trying to run it. Error code 91? Object variable or with block variable not set.

Thanks

Dim wdApp As New Word.Application, wdDoc As Word.DocumentSet wdDoc = wdApp.Documents.Open(Filename:=ActiveWorkbook.Path & "T:\Quality Management System\Section 7 Personnel\07.004 Animal Feed Jan16.docx", _
  ReadOnly:=True, AddToRecentFiles:=False)
With wdDoc
  .PrintOut
  .Close , False
End With
wdApp.Quit
Set wdDoc = Nothing: Set wdApp = Nothing

 

[yky]

Did the open method actually open the file (" wdApp.Documents.Open(Filename:=ActiveWorkbook.Path & "T:\Qu....")? I'm asking the question because it seems odd to have a path followed by a drive letter (ActiveWorkbook.Path & "T:\...").

 

[Macropod]

littleguy: Kindly familiarise yourself with the Forum Rules: http://www.mrexcel.com/forum/board-announcements/99490-forum-rules.html, inparticular-
Rule #4:
Members should not use the Private Message system to request specific assistance.

Rule#12:
Do not post duplicate questions.

Thread closed.