|
Posted to microsoft.public.excel.programming
|
|
|
Still Need Help closing excel and documents
Anyone
-----Original Message-----
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.
.
|