Excel object - To save or not to save [RESOLVED]

[joltremari]

What is the syntax to NOT prompt me to save the document.
I want to close it WITHOUT saving the changes.

msExcelWorkbook.Application.ActiveWorkbook.Save

Thanks for any help.

JO

[phinds]

If you want to close without saving, why are you doing a save command instead of just a close command with the nosave option?

check the object browser for method syntax

[TheBionicOrange]

you set the DisplayAlerts property of your Excel object to false.

This will stop screen prompting.

If you are leaving Excel open, then turn it back on at the end of your code, else your users could get mighty confused

[joltremari]

Thanks... DisplayAlerts, I don't know how I overlooked that!


I wasn't using that save command, I put it in the post because I thought the syntax for what I needed was something like this:

msExcelWorkbook.Application.ActiveWorkbook.Save Save:=False

and if it was then who ever answered would only have to copy and paste it instead of typing it all again...oh well


Thanks again

JO

displayalerts = false ---who'd-a-thunk it!