Hello Vasant,

Believe you are thinking of overwriting a file.

Application.displayAlerts = False
thisworkbook.SaveAs Filename:="C:\MyFolder\MyExistingFilename.xls"
Application.DisplayAlerts = True

In xl2003 help, at least, they point this exception out.


--
Regards,
Tom Ogilvy

"Vasant Nanavati" <vasantn *AT* aol *DOT* com wrote in message
...
Hi Tom:

I'm probably wrong <g, but I seem to remember that this is the one case
in
which Excel does not perform the default action (despite what Help says).

Regards,

Vasant

"Tom Ogilvy" wrote in message
...
Just a heads up for consideration:
I didn't test this particular case, but help says displayalerts = false
pursues the default action of the dialog.
Using displayalerts would suppress the prompt, but the default action
would
be taken and that is to save the file.

--
Regards,
Tom Ogilvy



"Darrin Henshaw" wrote in message
...
Set Application.DisplayAlerts to False, to not show the save changes
dialog box. However, that will stop Excel from prompting it, but still
give the user the ability to save it. You might want to look at the
BeforeSave event, to try to stop them from saving.




*** Sent via Developersdex http://www.developersdex.com ***