View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default Save without changes

Try something like

ActiveWorkbook.Close savechanges:=False
' or
Workbooks("EPLC.xls").Close savechanges:=False


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Jako " wrote in message
...
For example using this code:

Application.DisplayAlerts = False
ActiveWorkbook.SaveAs " "filepath\filename""
Application.DisplayAlerts = True

Will force the workbook to be saved without prompting from the

user.

What i want to do is close the ActiveWorkbook WITHOUT the

changes and
also without the Display prompts.

The active workbook is called "EPLC.xls" and as there will be

two
workbooks (or more) open i would rather, if possible refer to

the
"EPLC.xls" directly by name just to make sure nothing goes

askew.

TIA


---
Message posted from http://www.ExcelForum.com/