Hello, friends,

An Excel app was launched and a .xls file was opened using
Miscrosoft.Office.Interop.Excel. When I tried to close Excel using
Excel.Quit(), there was an Excel message box popped up, asking if one wants
to save the changes in the opened .xls file?

Can we get rid of this message and make Excel just close itself without
asking anything, event when a user does make some changes?

Thanks a lot for your help.

Andrew,

Before the Excel.Quit, with the xls file (referred to here as "MyFile"):

MyFile.Close SaveChanges:=False

hth,

Doug

"Andrew" <(E-Mail Removed)> wrote in message
news:074702C4-CD1D-4071-8C21-(E-Mail Removed)...
> Hello, friends,
>
> An Excel app was launched and a .xls file was opened using
> Miscrosoft.Office.Interop.Excel. When I tried to close Excel using
> Excel.Quit(), there was an Excel message box popped up, asking if one
> wants
> to save the changes in the opened .xls file?
>
> Can we get rid of this message and make Excel just close itself without
> asking anything, event when a user does make some changes?
>
> Thanks a lot for your help.
>
>

Application.DisplayAlerts = False

make sure you turn it back on at the Workbook_Open or else you'll never get
error messages again in that file.

HTH

"Andrew" wrote:

> Hello, friends,
>
> An Excel app was launched and a .xls file was opened using
> Miscrosoft.Office.Interop.Excel. When I tried to close Excel using
> Excel.Quit(), there was an Excel message box popped up, asking if one wants
> to save the changes in the opened .xls file?
>
> Can we get rid of this message and make Excel just close itself without
> asking anything, event when a user does make some changes?
>
> Thanks a lot for your help.
>
>