Sorry, I'm not exactly sure what you're asking. Specifically, I want to know
what I need to add to the following subroutine in Excel. If "temp.xls"
already exists, how do you capture the "Cancel" or "No" response on the
dialog box that asks if you want to replace the existing file.

sub test()
ActiveWorkbook.SaveAs ("temp.xls")
end sub


"Rody Meulman" wrote:

closemode? vbno?

"BHatMJ" schreef in bericht
...
Can anyone point me in the direction of expected returns when using
ActiveWorkbook.SaveAs (or Open). How do I capture a "Cancel" or "No"
selection?