| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Closing a file with macros
I want to close an excel file that has been modified but I do not want to be
ask if i want to save changes.. if I do as follows Windows("Excel file name.xls").Activate ActiveWorkbook.Close Excel will ask me if I want to save changes... I do not want this... just close it. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Closing a file with macros
hi
try this......... Application.DisplayAlerts = False ActiveWorkbook.Close Application.DisplayAlerts = True regards FSt1 "Alberto Ast" wrote: I want to close an excel file that has been modified but I do not want to be ask if i want to save changes.. if I do as follows Windows("Excel file name.xls").Activate ActiveWorkbook.Close Excel will ask me if I want to save changes... I do not want this... just close it. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Closing a file with macros
Worked great thanks.
"FSt1" wrote: hi try this......... Application.DisplayAlerts = False ActiveWorkbook.Close Application.DisplayAlerts = True regards FSt1 "Alberto Ast" wrote: I want to close an excel file that has been modified but I do not want to be ask if i want to save changes.. if I do as follows Windows("Excel file name.xls").Activate ActiveWorkbook.Close Excel will ask me if I want to save changes... I do not want this... just close it. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Closing a file with macros
Or
workbooks("Excel file name.xls").close savechanges:=false No need to activate it first. Alberto Ast wrote: I want to close an excel file that has been modified but I do not want to be ask if i want to save changes.. if I do as follows Windows("Excel file name.xls").Activate ActiveWorkbook.Close Excel will ask me if I want to save changes... I do not want this... just close it. -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Closing a file with macros
It is a very good option and will allow me to do even more.
Thanks "Dave Peterson" wrote: Or workbooks("Excel file name.xls").close savechanges:=false No need to activate it first. Alberto Ast wrote: I want to close an excel file that has been modified but I do not want to be ask if i want to save changes.. if I do as follows Windows("Excel file name.xls").Activate ActiveWorkbook.Close Excel will ask me if I want to save changes... I do not want this... just close it. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| closing a variable file name with macros | Excel Programming | |||
| Closing a Workbook if Macros aren't enabled. | Excel Programming | |||
| Enabling/Disabling Macros w/o closing & re-opening | Excel Programming | |||
| Closing Within Macros | Excel Programming | |||
| Error closing Excel after running series of macros | Excel Programming | |||
![Alberto Ast[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
