View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Doug Glancy Doug Glancy is offline
external usenet poster
 
Posts: 770
Default Can we make Excel close itself without asking anything?

Andrew,

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

MyFile.Close SaveChanges:=False

hth,

Doug

"Andrew" wrote in message
...
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.