Disturbing VBA trends

November 17, 2009JPNo CommentsRate This Article


    I feel the need to comment after witnessing a few disturbing trends in the Office developer community.

  • The news that the Office Developer Conference was folded into the SharePoint Conference.
  •     Are there not enough attendees, or is Microsoft not interested enough in Office development (the way it's been the last few years anyway) to maintain a separate conference? This seems like the start of a trend of marginalizing Office development as we know it (although I'm sure others would say it's been going on far longer than that).

  • John Durant's odd defense of VBA
  •     I like John Durant, but this defense comes off as weak. It ends up being a pitch for VSTO and/or .NET, and reeks of "pre-written." I feel like a player on a losing team whose coach is saying things like "it's OK, you played well and did your best." I like what Steve Schapel wrote about it, he called it "damning with faint praise" which could not sum up better what I see happening with Office development.

  • This photo from the SharePoint Conference (originally from Gray Knowlton's blog):
  • original

        There's that faint praise again. If every Microsoft employee at the SharePoint Conference wore "I love macros" t-shirts, then maybe I would start believing in their commitment to keeping VBA in Office. But this doesn't inspire confidence in me at all.

        On the other hand, Microsoft sponsored the last few UK Excel User Conferences, so maybe I'm just confused.

About JP
I'm just an average guy who writes VBA code for a living. This is my personal blog. Excel and Outlook are my thing, with a sprinkle of Access and Word here and there. Follow this space if you want to learn more about VBA. Keep Reading »

↑ Scroll to top
Previous Post:

Next Post:

5 Response(s) to Disturbing VBA trends ↓

  1. chrisham says:

    An advice required:
    With info like that, and somebody like me who is just a novice into VBA programming, would this be the right direction to be heading?
    Or should I be investing my time on something more advantageous than VBA.

    • JP says:

      I would still say yes, but don't put all your eggs in one basket. Learn VB .NET or C# (or something else like Java or PHP) to fall back on, in case the career writing VBA doesn't work out.

  2. Bob Phillips says:

    They could have chosen a better colour for the t-shirts though, I bet the .Net boys had a field day.

    BTW, MS did not sponsor the UK Excel Conference, they provided the venue and some basic facilities, but that was it. I am not complaining, it was very helpful and it is appreciate, but it seemed to be down to the efforts of a few of MS' employees, Vicki Collins, Akim Boukhelif and Phil Cross, I didn't see any corporate policy at work (other than maybe a policy to encourage the dissemination of information on MS products). The presenters paid ALL of their own costs, they were not subsidised FOR 1p.

  3. simon says:

    Chrisham:
    Learn VBA if it will help you now. That knowledge can be added and adapted later if you move in another direction.
    If VBA is not that relevant to your current situation then look at visual studio express (free), I'd recommend C# as this is where MS seem to be focusing these days. Or one of the open source alternatives like php.
    JP Office Marketing are not focusing on VBA in their marketing messages. at all! I think they wish we would go away, or move to VSTO.

Speak Your Mind

Tell us what you're thinking...

Certain comments (including first-time comments) are subject to moderation and will not appear immediately. Please view the Comment Policy for more information. To post VBA code in your comment, use tags like this: [cc lang='vb']Code goes here[/cc].




Site last updated July 26, 2010 @ 8:14 pm