Good afternoon all,
I have a macro that runs within a userform in Excel that opens up either 1 or multiple word documents for viewing and printing.
On the print, once they have printed, at the end of the macro I instruct closure of word.
Code
' at the start of the macro has the lines
Set AppWord = CreateObject("Word.Application")
AppWord.Visible = True
' at the end of the macro has this line
AppWord.Application.Quit
On the view function, once they view, the documents obviously need to to stay open to view and I want them to be able to go back to the userform and click a button that will close all documents that they viewed as they may have opened a maximum of 10 documents.
I am wanting a macro that when run, will close any and all word documents and quit word.
Possible?
Thanks in Advance