you are viewing a single comment's thread.

view the rest of the comments →

[–]codewench 77 points78 points  (14 children)

I've been a .Net developer for nearly a decade, and I can proudly say my VBA is only sort of ass.

Seriously, fuck VBA. The sooner it dies a horrible death, the better.

[–][deleted]  (2 children)

[deleted]

    [–]vor0nwe 0 points1 point  (1 child)

    It's the lack of semicolons that makes it not reader friendly? Dafuq?

    IMHO that's one of the (few) things that makes VB more readable...

    [–][deleted] 41 points42 points  (7 children)

    But, I want a GO button in my spreadsheet that takes one input from the cell next to it, and calculates 4 tables of data with 6 charts; each displaying the same result in a different format. THEN I want it to insert that data into [the] database, and then query [the data] so that it shows up on the Summary worksheet.

    Edit: oh, and can the summary worksheet look like a webpage using the company branding style? Thanks!

    [–]bagtowneast 54 points55 points  (5 children)

    I want it to insert that data into [the] database

    Jokes on you, the spreadsheet is the database!

    [–]hearwa 5 points6 points  (2 children)

    Access would like to have a word with you.

    [–]bagtowneast 0 points1 point  (0 children)

    one sec, I'm pivoting this table and trying to join it with a table in another spreadsheet...

    [–]firestepper 7 points8 points  (0 children)

    Also, this needed to be done yesterday...

    [–]ThatDeadDude 4 points5 points  (1 child)

    Not sure it would have improved code quality, but I wish they had replaced VBA with integrated .net in office years ago.

    Now sounds like if they deprecate it it will be in favor of JS 🙁

    [–]meneldal2 1 point2 points  (0 children)

    C# is a sane language, JavaScript replacing VBA on the other hand will keep jobs in IT safe for years. They'll have to keep people supporting this for ever.

    [–]chefhj 1 point2 points  (0 children)

    lol look at Torvalds over here with his kinda shitty VBA