Closing w/Save an Excel file from a Word macro

[Mark Eidemiller]

I have a Word macro that opens a merge document and also opens the
corresponding source file in Excel. But when the macro closes the Word
document, the Excel spreadsheet won't close until I answer the prompt for a
save. How do I get the Excel spreadsheet to close without prompting?

Thanks.

 

[Rick Stebbins]

Try setting the Saved property of the workbook to True
before closing the Word document.

 

[Mark Eidemiller]

How do I do that?

Try setting the Saved property of the workbook to True
before closing the Word document.

 

[Cindy M -WordMVP-]

Hi Mark,

I have a Word macro that opens a merge document and also opens the
corresponding source file in Excel. But when the macro closes the Word
document, the Excel spreadsheet won't close until I answer the prompt for a
save. How do I get the Excel spreadsheet to close without prompting?

If mail merge is opening the Excel file, this means you've used a DDE
connection to the Excel file. Chances are, you won't find any good way to
automate closing this Excel file again.

Much better would be to use an ODBC connection to the Excel file. But you
need to tell us which version of Word you're using before we can tell you how
to get an ODBC connection.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep 30 2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail

 

[Mark Eidemiller]

Word 2000 (9.0.6926 SP-3).

Hi Mark,

If mail merge is opening the Excel file, this means you've used a DDE
connection to the Excel file. Chances are, you won't find any good way to
automate closing this Excel file again.

Much better would be to use an ODBC connection to the Excel file. But you
need to tell us which version of Word you're using before we can tell you how
to get an ODBC connection.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep 30 2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail