View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Michael Wise Michael Wise is offline
external usenet poster
 
Posts: 5
Default Need Help closing excel and documents

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.