Keithieopia

You have a Excel sheet that has column headers in the first row, similar to a CSV. Using VBA, grab a column of data given a specific column header. Should be easy right?

If you’re setting up a new Magento 2 webstore with a new PayPal account as your payment processor, you’ll probably run into this bug: a zero dollar charge in PayPal Payflow (manager.paypal.com) that was processed successfully, zero dollars regardless of the actual sale price. In Magento, it will say payment declined, even though PayFlow shows the payment (of zero dollars) was approved.

It’s a new year over at CVS Pharmacy and a perfect time to change phone tree options since someone posted an opt-out guide and an investigative journalist wrote an exposé on the annoying calls.

Not all heros wear capes, and in this case Greg S. wrote to me with an updated 2019 guide. In May, Robert A. contacted me with some helpful addendums.

Included in almost every self-help book, motivational speaker’s presentation, and even religious tenets, there’s usually something included along the lines of “We should be nice to each other”. I’m going to present an antithesis that you should not be nice to others and yet you should also not be mean.

For those that have never heard of it, Footprints in the Sand is an popular religious poem with a disputed origin ultimately resulting in a lawsuit. I had wanted to feature this beautiful poem on decorative sign, but found the ugly nature of it’s legal status to be off-putting.

These time ranges are valid as of 2018 for attackers that might have stolen a database from a third-party website you use.

There are two types of people in this world: those that have a complete spice rack in the kitchen and those that have a bottle of all-purpose seasoning on the dining table. Likewise, what people call a dash is actually an en-dash, em-dash, or a hyphen. To be clear, this post has nothing to do with Mrs. Dash.

Recently we’ve started receiving numerous “refill reminders” from CVS for someone we don’t know. The inexplicable part is we’ve had the same phone number for several years; these calls just started out of the blue.

I enjoy reading about other countries and cultures, so it’s no surprise I frequent international websites. One reoccurring misconceptions I come across is that non-Americans believe “American” means something beyond national borders.

If you want to find the creation date of a file in a git repo, you can issue the following command. Replace [FILENAME] with the respective file):

git log -1 –format=“%ai” –reverse [FILENAME]

Given all the renewed interest in privacy rights in the so-called Post Snowden Era, I’d thought I’d clarify a misattributed quote floating around: “You have nothing to fear, if you have nothing to hide”

My wife is a fan of the TLC show Say Yes to the Dress. Knowing my Google-fu, she gave me the task of identifying the song that plays when the brides find their dress. It proved to be pretty difficult to find online even with part of the lyrics.

In grade school, I had a teacher that played a game called Rare Birds with each of her classes. The object was to silently write down three unusual facts about yourself that where not easily guessed. Once everyone was done, the teacher walked around and collected our slips in this ridiculously looking Dr. Seuss hat.

For all my life I have had a disability called Central Auditory Processing Disorder (CAPD). People with CAPD have great difficulty understanding what others say, especially when in noisy environments such as cafeterias, playgrounds, gyms, bars, and public sporting events.