Re: Difference between Quit in Word and Excel

Tech-Archive recommends: Speed Up your PC by fixing your registry

Hi Mjwills,

Yes, they behave differently. Another anamoly I seem to recall coming
across is that, if you have an object variable set to an instance of
Excel, and set it to Nothing, that will usually close Excel. But that's
not the case with Word. Word will let you set the object variable to
nothing, yet remain open for the user to continue work.

But I'm sorry, no, I don't know of any place where these differences are
documented.

> As background to my issue, I have noticed that .Quit in MS Word (97 /
> XP) and .Quit in Excel (97 / XP) seem to have quite different
> behaviours. In particular, .Quit results in the Word process unloading
> from memory, while .Quit in Excel allows Excel to be unloaded from
> memory only if there are no references to objects within the Excel
> process.
>
> My question is to identify whether *MS has stated that the behaviour I
> am seeing (see below) is documented and reliable* (ie will always
> happen).
>

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

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

.

Quantcast