Excel VBA: We hates it! We hates it! We hates it for ever and ever!

One of my new-year resolutions was that I would endeavour to allow certain portions of my brain to dry up, rot away and never be used again.

Brain segments marked for deletion are those containing skills for:

  • MS Access
  • Crystal Reports
  • Word VBA
  • Excel VBA
  • VBA in general

Although these are all excellent tools in themselves (I frequently use them for my own purposes) I loathe working in them professionally. They quickly lead to messy, ill fitting, amateur solutions that are not scaleable, not tamper proof, hard to re-use, and suffer from terrible lock-in.

But when a salesman walked into the technical area yesterday and asked:

"Who here knows excel?"

Like a fool I put up my hand and said things like, "Sure! Yep! Pick me! I'll do it!"

And in no time i'm trapped in one of these fiddly micro-projects that you just know is going to get real messy real quick.

 

I'm currently writing a book about how to build your first product. If you want to build your first product, please sign up to be notified when the book is available.

(By the way, I read every comment and often respond.)

Your comment, please?

Your Name
Your Url (optional)
Note: I may edit, reuse or delete your comment. Don't be mean.