Close workbook without saving file
Try
ActiveWorkbook.Saved = True
ActiveWorkbook.Close
From XL 2003 Help:
You can set this property to True if you want to close a modified
workbook without either saving it or being prompted to save it.
HTH,
JP
On Mar 6, 9:37*am, 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.
|