When testing to ensure conditions are safe for processing to continue Private Sub CheckConditions is it recommended to log errors/send emails, etc. within the check or to have reporting external? For example:
CheckConditions
If okToProceed Then
DoStuff
Else
ReportErrors
End If
Where CheckConditions sets okToProceed appropriately (as a member of the class).
Or would it be presumed that CheckConditions would also send an email notifying of a failure status (nightly process, nobody's monitoring for error messages). That would, of course, be doing more than what it says on the tin, so probably not.
Of course, Private Function CheckConditions() as Boolean streamlines the code above...
I keep seeing the same questions pop up for VBA questions on SO and it's demoralizing. I know people hate getting their questions closed as duplicate and yet new users just fail to find their answers. Por Que?
I agree. It's unfortunate how much time is spent closing dupes, editing low-quality questions, downvoting terrible questions ... as opposed to adding new, high-quality answers.
A comment along the lines of "5 seconds of searching on your behalf brought me to this duplicate question." I have a text file of canned responses I copy/paste as necessary.
Maybe, just maybe, with enough hints applied with a 2x4, people will start to learn.
Since this problem has plagued all internet forums since the very first one, Usenet, a larger systemic issue needs to be addressed. New user introduction. SO actually has things in place to help this but it remains unsolved.
I've seen systems where you have to interact with a chat bot before you're allowed to post. Maybe something like this will become a standard at some point. If you can convince the chatbot you know what you are doing it gets out of your way. New user AI. The internet could gatekeep itself.
The bots you have seen so far. That's why it remains unsolved. I think there are some really advanced AIs that we haven't had the pleasure of interacting with yet.
I must admit, the ones commonly found in phones are pretty single minded.
You know you are on a loser when the poster starts with 'I am new to VBA"( especially if the add a 'lol') which is short for I've started messing about with VBA in excel but haven't bothered to work my way through a VBA tutorial or do any other reading which might help me. Please write my code for me/ I found this code which nearly works etc etc etc.
A better question is why do high rep experienced users with gold badges continue to answer blatant duplicates instead of closing them :sigh: -.- — NickNov 30 '21 at 11:12
yeah not surprised. There's no incentive to curate.
I mean, imaginary Internet points and whatever, there's none of those for closing dupes, editing tags, fixing code blocks, commenting to read how to ask a question. It's unfortunate. Gotta remember to not let the negativity drag me down.
Besides, who really cares about imaginary Internet points?
VBA Rubberducking
VBA Rubberducking