Thread
:
Close workbook without saving file
View Single Post
#
8
Posted to microsoft.public.excel.programming
Dave Peterson
external usenet poster
Posts: 35,218
Close workbook without saving file
You've got to be careful with your syntax:
Windows("file_name.xls").Activate
ActiveWorkbook.Close savechanges:=False
or just:
workbooks("file_name.xls").Close savechanges:=False
wrote:
Good morning,
I am aware that this issue has been raised
several times, however, i have yet to find a string of code that
actually gets RID of the "would you like to save prompt"!
I am using excel 2003 and i have tried all of the codes below with NO
success:
1) Windows("file_name.xls").Activate
ActiveWorkbook.Close (savechanges = False)
2) currentWorkbook.Close savechanges = False
3) Application.DisplayAlerts = False
ActiveWorkbook.Close
Nothing i have tried from previous articles has helped; any advice
would be greatly appreciated.
--
Dave Peterson
Reply With Quote
Dave Peterson
View Public Profile
Find all posts by Dave Peterson