closing without saving within a macro

O

okanem

I am trying to close a spreadsheet without saving any changes to it from
within a macro, but at the moment it keeps asking me do I want to save
changes.

The code so far is

Windows("control of contract - item 1.xls").Activate
ActiveWorkbook.Close

Can someone help.

I don't want to save before closing which would get rid of the message
because it takes about 10 seconds to close.

Thanks for any replies
Okanem
 

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

closing file without saving 1
Closing temp worksheet without saving 4
Macro to close without saving 5
VB Syntax to close Excel workbook not saving changes 1
VBA - closing without saving changes 2
Macro closing Excel file without saving changes 1
Close without saving 5
Closing a file with macros 4

Top