Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can we make Excel close itself without asking anything?
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can we make Excel close itself without asking anything?
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
why do all excel worksheets/workbooks close when I close one? | Excel Discussion (Misc queries) | |||
Not close thead when I close excel | Excel Programming | |||
Macro to make excel close | Excel Programming | |||
Excel shoud not close all active books when clicking close button | Excel Discussion (Misc queries) | |||
excel - Windows close button (x) should only close active workboo. | Setting up and Configuration of Excel |