Why VBA? (Part 1)

(Part 1 because I might want to ramble on a bit longer…)

Why VBA? Well, VBA has been getting some bad press recently – see here in The Register, for example. The case against includes these points:

  • It’s from Microsoft, and therefore is at odds with the Brave New World of free software and open source (of which I’m fully supportive, by the way).
  • Its use raises some security isues.
  • As a language, it’s a bit of a mess, in terms of syntax, and other historical baggage.
  • It encourages people who aren’t ‘proper programmers’ to write code, which is often of poor quality.
  • Its long term status is unclear.

On the other hand:

  • It’s available to ordinary computer users in a way that no ‘proper’ programming tools are.
  • It can significantly increase the capabilities of applications such as Excel.
  • It enables ‘micro-development’: do a tiny amount and get it working.
  • It can be used in a disciplined and effective way, just like anything else.

I’ll look at these various points, pro and con, in turn.


1 Response to “Why VBA? (Part 1)”

  1. 1 Hildegard August 6, 2013 at 6:51 am

    Remarkable issues here. I am very happy to see your post.
    Thank you so much and I’m looking ahead to touch you. Will you please drop me a e-mail?

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

January 2009
    Feb »

%d bloggers like this: