MrExcel Publishing
Your One Stop for Excel Tips & Solutions

File | close Save=no

Posted by Sean Tobin on July 31, 2001 11:59 AM

I have a macro that changes data in one spreadsheet and then closes it and moves on. When the macro is run, a prompt pops up and asks whether I want to save it. I click "no" and the macro continues. I can't seem to get the macro to do this automatically. Any help?

Posted by Russell on July 31, 2001 12:31 PM

ActiveWorkbook.Save False

Just use the line in the subject line.

Hope this helps,


Posted by Russell on July 31, 2001 1:14 PM

Oops, I meant: ActiveWorkbook.Close False

Sorry about that.