Close workbook without saving file
I've used
Application.DisplayAlerts = FALSE
Save code
Application.DisplayAlerts = TRUE
with success. I usually do this though so that I know I'm working on the
correct workbook.
Dim aWB as Workbook
Set aWB = Nothing
on Error resume next
Set aWB = Workbooks("file_name.xls")
on error goto 0
if Not aWB is nothing then ...
Do whatever you'd do with the aWB.
end if
--
HTH,
Barb Reinhardt
" 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.
|