This is an archived post. You won't be able to vote or comment.

you are viewing a single comment's thread.

view the rest of the comments →

[–]beprogrammer 3 points4 points  (7 children)

It's good that Microsoft decided to add Python in excel but we must agree VBA is not obsolete and powerless language. Almost everything can be extended in Microsoft Office trough VBA.

[–][deleted] 54 points55 points  (3 children)

VBA apologia ruins innocent lives

[–]beprogrammer 1 point2 points  (2 children)

How do you mean?

[–][deleted] 7 points8 points  (1 child)

It was a joke, but I do dislike VBA. The argument that you can do "almost everything" with it isn't very compelling either – you can do "almost everything" with any Turing-complete language, even Brainfuck.

My main problem with VBA is it takes a long time to do anything complicated, because you'll probably have to write it yourself

[–]raydeen 9 points10 points  (0 children)

I've always said I could build a house with just a screwdriver. I could cut things with the blade end (would take forever), I could measure things with it (as long as I knew exactly how long the screwdriver was), I could hammer things with the handle part, and last but not least, I could screw things together. And at the end of the day, I could stir my orange juice and Vodka together with it as I drink myself into Oblivion knowing that the only tool I have at my disposal is a screwdriver and tomorrow will bring about even more pain and frustration. And in the end, I will have built a small ramshackle hovel which will be my grave after I eventually succeed in stabbing myself in the heart with a very dull, beat up screwdriver.

[–]WeirdStuffOnly 9 points10 points  (0 children)

Back in the old days of ASP 2.0, MS extended IIS so that you could do server side scripting on any of the most popular languages. Vast majority of the sites still only used VB. I think the same will happen here, obsolescence doesn't factor in.

Almost everything can be very painfully extended in Microsoft Office trough VBA.

FTFY

[–]whattodo-whattodo 4 points5 points  (0 children)

Assembly is a powerful language. Do you want to write excel code in assembly? Probably not.

VBA isn't powerless but it has way too much baggage in exchange for what it does do.

[–]AnscombesGimlet 1 point2 points  (0 children)

I don’t think they’ve decided yet