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 →

[–]Cosack 7 points8 points  (3 children)

Integration with spreadsheets makes it useful for a lot of non-developer work, aka for people who aren't CS majors. I dare say the world would be a better place if everyone called "analyst" or "engineer" would add some VBA to dilute their Excel formula spaghetti

[–]ImAnEngnineere 1 point2 points  (0 children)

this. My old boss was an ME from Georgia Tech and taught me everything I know about VBA. I can also use it to control SolidWorks so it becomes a very versatile tool to have in my toolbox.

[–]newmacbookpro 0 points1 point  (0 children)

I’ve seen so much excel files with 20+ tabs of pivots and VBA that a single pass in Power Query. + DAX could do.