I'm having trouble with adding a feature to prompt the user to save the file
under a different name. I need it to force the user to save it. The
trouble is that if the user chooses a file name that exists he/she is asked
to overwrite the file or not. If I choose 'No' or 'Cancel' it creates an
error. I can trap the error and try to resume but all this does is loop
through the overwrite prompt, effectively forcing the user to overwrite the
file.

Is there a method to determine and handle the output from the overwrite
dialog, make choices based on which button was pressed?