Macro closing Excel file without saving changes

W

windsurferLA

The VBA code

If Dir("opening test2.xls") <> "" Then Kill "opening test2.xls"

closes the file, but only after a dialog box response approves closing
without saving. How does one close the workbook without the need for
approving the closing in a dialog box?
 
D

Dave Peterson

Kill deletes the file. It doesn't close the file.

If you want to close a workbook without saving, you could use:

workbooks("opening test2.xls").close savechanges:=false
 

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

Update cell links between 2 excel file without opening source file 0
closing file without saving 1
closing another file by code causes failure to run workbook activate event 2
Word 2010: trouble saving font/size 9
Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
Command works from debug but not normally 6
Custom Document Properties in Word documents and Excel workbooks 15
Word macro that can call cells out of Excel for a find and replace 0

Top