checking if file exists.

[rache1]

Hi.

I have this application that loads the Common Dialog Box whenever a user clicks on Save Button. I need to check if the filename the user entered is existing and prompts the user if the file is to be overwritten.

I have set the common dialog flag as :
CommonDialog1.Flags = cdlOFNOverwritePrompt
CommonDialog1.ShowSave

this will automatic prompts the user in form of a msgbox if the file is to be overwritten, but how do I check what the user has clicked i.e. Yes or No on the msgbox, is there a way to detect?

Thanks for the help.

 

[sunaj]

I don't know if this is what you're looking for, but I usually have something like:
if CommonDialog1.Filename<>&quot;&quot; then exit sub 'user cancels
if dir(CommonDialog1.filename)<>&quot;&quot; then kill CommonDialog1.filename 'the user has click 'yes' to overwrite promt

If the user selects 'cancel' the CommonDialog will return empty and the file will not be deleted. (When the user selects 'yes' or 'no' to the overwrite promt (s)he will return to the CommonDialog and has to selct 'ok' or 'cancel'.