 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Programming / April 2006Close Excel after mail merge
Hi All, After a mail merge, closing Excel prompts the alert " Do you want to save the excel file ?" Getting rid of this alert message seems tough ... Application.DisplayAlerts is not operative oXL.Quit does not allow to skip this alert ... I am looking for your recommendations Thanks in advance Carim You will need to close the workbook before quitting. You can tell it to close the workbook without saving the changes. > Hi All, > [quoted text clipped - 6 lines] > Thanks in advance > Carim Hi zkid, Will give it a try. Thanks for the advice. Carim Just tried to close workbook ... but unfortunately the Alert message keeps coming ... Still looking for suggestions. Thanks in advance Carim You need to tell Excel that you don't want to save the workbook --- ActiveWorkbook.Saved = true > Just tried to close workbook ... but unfortunately the Alert message > keeps coming ... > Still looking for suggestions. > Thanks in advance > Carim Hi Jezebel, Thanks a lot ... I think this will solve my problem ... I did not know this property Thanks again Cheers Carim Hi, For the sake of documentation, the solution is a bit different ... Thanks to Cindy ... unlinking the template to its source is a prerequisite : ActiveDocument.MailMerge.MainDocumentType = wdNotAMergeDocument Then Closing the template without saving changes ... ActiveDocument.Close SaveChanges:=wdDoNotSaveChanges HTH Carim That's for closing Word. Your subject line asks about closing Excel, which doesn't do it that way. > Hi, > [quoted text clipped - 7 lines] > HTH > Carim |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.