Closing a file with macros

A

Alberto Ast

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.
 
F

FSt1

hi
try this.........
Application.DisplayAlerts = False
ActiveWorkbook.Close
Application.DisplayAlerts = True

regards
FSt1
 
A

Alberto Ast

Worked great thanks.

FSt1 said:
hi
try this.........
Application.DisplayAlerts = False
ActiveWorkbook.Close
Application.DisplayAlerts = True

regards
FSt1
Click to expand...
 
D

Dave Peterson

Or

workbooks("Excel file name.xls").close savechanges:=false

No need to activate it first.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Function to perform on closing an Excel Workbook 4
automation error when closing excel 3
VB Syntax to close Excel workbook not saving changes 1
Macros problem closing another file 0
Help with copying a sheet from One workbook to another workbook 1
closing file without saving 1
Toggling save warning message on or off 9
Sheet that never closes 4

Top