Closing Excel data source from Word

Mar 12th, 2002, 01:11 AM

After completing a mail merge using Word with an .xls as the datasource, how do I close the datasource without saving from Word.

Nigel Martin · Mar 12th, 2002, 05:43 AM

Assuming you have mail merged to a new document why not close your mail merge original document which will prompt for saves etc. closing Excel along with it (after prompts) thus leaving your new mail merged document open with Word running but not Excel.

Hope this helps.

Mar 12th, 2002, 06:01 AM

After the mail merge completes, it does a printout and then closes Main document, leaving the excel data source as the active window. Using "ActiveWindow.Close SaveChanges:=False" from Word brings up a box asking "Do you want to save changes ?(to the datasource). It is this box we do not wish displaying. Excel is still open with other workbooks.

Eugene Robinson
Rhos on Sea Wales

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 12th, 2002, 01:11 AM	#1
Guest Posts: n/a	After completing a mail merge using Word with an .xls as the datasource, how do I close the datasource without saving from Word.

Mar 12th, 2002, 05:43 AM	#2
Nigel Martin Board Regular Join Date: Feb 2002 Posts: 133	Assuming you have mail merged to a new document why not close your mail merge original document which will prompt for saves etc. closing Excel along with it (after prompts) thus leaving your new mail merged document open with Word running but not Excel. Hope this helps.

Mar 12th, 2002, 06:01 AM	#3
Guest Posts: n/a	After the mail merge completes, it does a printout and then closes Main document, leaving the excel data source as the active window. Using "ActiveWindow.Close SaveChanges:=False" from Word brings up a box asking "Do you want to save changes ?(to the datasource). It is this box we do not wish displaying. Excel is still open with other workbooks. Eugene Robinson Rhos on Sea Wales