LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Closing workbooks w/o closing Excel Barb in MD Excel Discussion (Misc queries) 3 February 15th 10 06:42 PM
turning 2007 excel documents into 2003 excel documents La Shawn Dillon Excel Discussion (Misc queries) 2 February 15th 08 11:23 PM
excel documents won't open from my documents folder Paul1961 Excel Discussion (Misc queries) 2 January 15th 06 05:31 PM
Excel Documents Don't Appear in My Recent Documents Addi Excel Discussion (Misc queries) 4 July 24th 05 09:43 PM
closing excel after closing a workbook CWalsh[_2_] Excel Programming 3 January 21st 04 03:33 PM


All times are GMT +1. The time now is 05:45 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"