FaheemAhmadGul
asked on
VBA Code to close the ActiveDocument without saving it.
In a Word Macro I have a line that closes the ActiveDocument like this
ActiveDocument.Close
However, when the above line of code runs, I get a message box giving me three options: Save, Don't Save, Cancel.
I am wondering if there is a way closing ActiveDocument without letting this Message Box popup or to close this MessageBox through the code so that the user does not have to chose from the three options. I would like to always Close with Don't Save Option in Macro.
So basically I am looking at a way of closing the ActiveDocument without having to manually say Don't Save.
ActiveDocument.Close
However, when the above line of code runs, I get a message box giving me three options: Save, Don't Save, Cancel.
I am wondering if there is a way closing ActiveDocument without letting this Message Box popup or to close this MessageBox through the code so that the user does not have to chose from the three options. I would like to always Close with Don't Save Option in Macro.
So basically I am looking at a way of closing the ActiveDocument without having to manually say Don't Save.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You’re welcome and I’m glad I was able to help.
If you expand the “Full Biography” section of my profile you’ll find links to some articles I’ve written that may interest you.
Marty - Microsoft MVP 2009 to 2017
Experts Exchange MVE 2015
Experts Exchange Top Expert Visual Basic Classic 2012 to 2017
If you expand the “Full Biography” section of my profile you’ll find links to some articles I’ve written that may interest you.
Marty - Microsoft MVP 2009 to 2017
Experts Exchange MVE 2015
Experts Exchange Top Expert Visual Basic Classic 2012 to 2017
ASKER
I would certainly study articles written by you. What I find very interesting in your profile is that your original degree was in Organic Chemistry. This gives me hope that I can also learn programming one day.
You would have already guessed from my silly questions on VBA I am not a professional programmer. I am a hobbyist with a degree in a completely diferent field, though I am much better in .NET and C#.
I use VBA macros only to make some parts of my personal routine work easier.
You would have already guessed from my silly questions on VBA I am not a professional programmer. I am a hobbyist with a degree in a completely diferent field, though I am much better in .NET and C#.
I use VBA macros only to make some parts of my personal routine work easier.
ASKER