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"