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.

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.

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.

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

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