Error Handler If User Does Not Want to Overwrite File

ChrisOK · #4 04-03-2020, 04:50 PM

Ok Bob, finally got a chance to test it tonight - and appears I still have something wrong.. This error handling is new..

but likely important to start incorporating..

I put the On Error part at the very top (just below the name of the Sub) as directed... then added the ErrHandle: piece below the 'SAVE RESULTS FILE' section

Getting a compile error: Else without If (screenshot attached)

If the user chooses "Yes" then I'd like it to continue w/ scripts
If the user chooses "No" or "Cancel" (which is giving the 1004 error) l'd like the script to just end w/ a MsgBox "Exiting Sub"

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
MS Word Error: This file is in use by another application or user	conky	Word	4	02-26-2019 09:21 AM
How can I get Outlook from one user to another w/o a .pst file (primary user on computer is corrupt)	Tenmakk	Outlook	0	03-01-2015 12:49 PM
How to Control Worksheet Event Handler in Module?	tinfanide	Excel Programming	2	10-19-2014 09:46 AM
Stop macro if no file is selected in dialog box (when user presses cancel instead of selecting file)	spencerw.smith	Word VBA	2	08-12-2014 07:56 AM
Word does not ask do i want to overwrite a file on saving a file	sam2149	Word	2	03-24-2014 04:18 AM