Don't want to over write existing without a prompt

[julhs]

This is a cross post, that appears to have gone cold. Hoping someone here can help me complete my puzzle.
I would dearly like to put this one to bed, your help would be greatly received.

Cross posted here: http://windowssecrets.com/forums/showthread.php/159738

As my code is, a new Word Document is created & saved, if it exists already it simply over writes the original without any prompt or option to manually give it a different name.
I would like to;
a) have option of renaming it manually
b) have option of overwriting it or not

Please Login or Register  to view this content.

By including the code below I thought I would simply be-able to manipulate the MsgBox arguments to achieve that.
However syntax will not allow me to have a YesNo MsgBox option

Please Login or Register  to view this content.

[slx]

Please Login or Register  to view this content.

[julhs]

Six, thanks so much.

Now I can see where I was going wrong.
Have had a very quick play around with it, and with some more juggling of the code layout I believe we could be there.
Will post back a completed version when done.

Thanks again, you’re a life saver.

[julhs]

Six, many thanks for the pointer. Below is how it turned out.
Decided to leave out the renaming part; it did work but it all got a bit messy with the "If's"
In the end; took the “Not” out of If Not Dir(strFilename), only because it was easier to handle this way around, the couple of extra
If’s and that was it.

Please Login or Register  to view this content.