Need Help closing excel and documents

  • Thread starter Thread starter Michael Wise
  • Start date Start date
M

Michael Wise

Here's my problem. I am running some Vb in excel and at
one point I open a word .dot to mail merge some
information. I would like to close the excel without
saving the workbook and close the .dot without saving it
as well. This should leave me with my open merged .doc.
Here is the code i'm at so far:

Dim WordApp As Object
Set WordApp = CreateObject("Word.Application")
WordApp.Documents.Open "c:\PSV Travelog\Travelog
Template.dot"
WordApp.Visible = True

What do I add to perform the above after this takes place.
 
Back
Top