Application.Quit
elcroco wrote:
I would like to use this function in one of my application.So I wrote
the following code:
Sub sTestAppQuite()
Application.Display
Application.Quit
End Sub
When I m testing it, the "Save" dialog box opens, asking me whether or
not I want to save the workbook. As I would like to avoid this
behaviour, what I hhave to do ???
Areyou sure that the user won't have another file open and lose work in
that?
You could set thisworkbook.saved = true, which will tell Excel that
there are no chanegs to save. If there is only one workbook open, Excel
will quit; if there is another workbook the user will be prompted to
save changes if there are any.
Nik
|