I'm using saveas method to save new file to new name. But, when a duplicate file name exists, the conflict dialog box appears. Macro does not fail if clicking YES (Ok so far), but it does fail when clicking NO or CANCEL. How do I take what the user clicks and skip the save if user clicks NO or CANCEL, and get the macro to move on w/o failing.
I tried saving "result" of method to integer variable in hope to "use" that, but that didn't work either (2nd bit of code below).
What is best way to interpret user's answer and follow suit in the macro code??? Do you turn off errors for this step???
Bookmarks