Error Handling - Copy Folder VBA

[jsherwood]

I grabbed some VBA online and made a few small edits. The VBA copies a specified folder and allows me to rename and save. Problem is if I click cancel on the dialog box it still saves as a "FALSE". I need it to not overwrite an existing file and also exit the sub if cancel is clicked.

Sorry, a little new and still learning. Any help would be greatly appreciated!

Please Login or Register  to view this content.

[PCI]

Your post does not comply with Rule 2 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Click on Edit to open your thread, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 6)

[jsherwood]

Thank you, I updated that.

[PCI]

if I click cancel on the dialog box

which dialogbox ? what is the message with the dialogbox

It seems thet the dialogbox used are only for display no input

[jsherwood]

The save as dialog box. If I click cancel at that point it still copies the folder with the name false.

[PCI]

To avoid misleading can you open the macro and go step by step ( using key F8) and mention when you are asked to save with Cancel option

[PCI]

Got it ... perhaps
see next code

Please Login or Register  to view this content.

[jsherwood]

The save as dialog box opens right after the ToPath = Application.GetSaveAsFilename step. I may have something misplaced here? Fairly new to VBA......appreciate you responding.
Capture.JPGCapture2.JPG

[jsherwood]

Fantastic! Works like a charm! Someday I will be up to this Jedi level.......until then I will be the one asking questions and not responding to them.

Thank you!

[PCI]

I will be up to this Jedi level

no, still not at the guru and still learning ...!