Overwrite File If Select NO

[gophins]

Hi,

I know I can turn off the alerts by using

Please Login or Register  to view this content.

However, in a particular juncture in the macro I don't want to turn off the alerts, if people are overwriting the file they should be prompted, if they select YES then the macro should continue (and it does), however if they select no it prompts the DEBUGGER.

I want a Msg Box to pop up if they select no that says: YOUR PLAN WAS NOT SUBMITTED.

How can I do that? Thanks for any help!!!

[Leith Ross]

Hello gophins,

Here is an example.

Please Login or Register  to view this content.

[gophins]

But what if the prompt is not mine, it is excel's, so when I say

Please Login or Register  to view this content.

I'm not really responding to a msg box that I created. So when Excel prompts: A filne named X already exists... Do you want to replace it? If I select yes, the macro continues (which is what I want), if people select No or Cancel, I want them to be prompted with the Msg Box "Your Plan was Not Submitted." and then Exit Sub.

I don't know if I'm explaining it right...

Thanks

[Leith Ross]

Hello gophins,

You don't need to respond to this dialog, you need to prevent it from being displayed. You're getting this message because of an error that can be avoided. You only need to test if the file or folder exists before you attempt to create it.

Please Login or Register  to view this content.