CodeGolf Answer Explained: Removing Vowels

I participate in challenges at CodeGolf.SE (part of the StackExchange network), so from time to time, I will set aside some effort to elaborate on certain solutions I provide.

Today's solution (which can be found by following this link) is in response to a question titled: "Remove vowels without using too many different characters"

CodeGolf Answer Explained: Printing The Alphabet

I participate in challenges at CodeGolf.SE (part of the StackExchange network), so from time to time, I will set aside some effort to elaborate on certain solutions I provide.

Today's solution (which can be found by following this link) is in response to a question titled: "Print the alphabet without using each vowel"

Opinion: Oh, So You Recorded a Macro?

This statement is quite insulting and condescending to me, especially so when the person saying it knows little about the amount of coding involved with the ‘macro’ in question. I program as a hobby, with a little experience in this and that. While coding this or that in VBA/Office can be simplified by recording your steps, there is actually a lot that either can't be done by simply recording, and also much that can be done more efficiently than what was recorded.

Code Example: Better InStr() Function

Sometimes you want to find out how many times some substring appears in a string (well, maybe you don't), but the standard InStr() just doesn't cut it by itself. The code below allows you to actually grab each instance of that substring in an array you can work with.

Code Example: Time in MS Access

“How do I display a time over 24 hours in MS Access?”

I’ve run into this problem a lot over the years, and I always end up having to Google up the answer. In doing so, I’ve seen numerous messages boards with the same question, yet frequently no answer, which leads to more digging and time wasted.

Well, here’s a solution that works…