Hi all,

Is there a way to tell excel not to prompt for "Do you want to save changes, blah blah blah").

I just want to spreadsheet to be closed without prompting.

Many thanks
Kempes

application.displayalerts = false

thanks. I'll give that a go.

also, I've played around with another save option for when i do want the user to save a copy. For this I used Application.GetSaveAsFilename, which gives the save window and looks like it has worked, but the file has not been saved down.

any ideas?

Yep read the helpfile. Here's how it begins:


GetSaveAsFilename Method

Displays the standard Save As dialog box and gets a file name from the user without actually saving any files.



Have a look at the "saveas" and "savecopyas" methods instead.

got it.

used the above as a string, then put this string in the saveas method to trigger the full save as process.

Thanks for your help.

Kempes