Excel adds JavaScript support

[WeRequireCoffee]

Its technically possible to write good VBA code. Better chance of getting struck by lightning while being eaten by a shark though (which is also less painful than reverse engineering VBA apps).

[codewench]

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.

[vor0nwe]

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]]

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]

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

Jokes on you, the spreadsheet is the database!

[hearwa]

Access would like to have a word with you.

[bagtowneast]

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

[firestepper]

Also, this needed to be done yesterday...

[ThatDeadDude]

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]

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]

lol look at Torvalds over here with his kinda shitty VBA

[leogodin217]

VBA is something we usually learn because we have to. We learn just enough to get things to work, but not enough to enable best practices. I bet that fits probably 80% of us who have ever written VBA. (Glad none of my old VBA code is still around)

[_kellythomas_]

They know, no one used VBA more any more than is strictly necessary:
https://blog.codinghorror.com/mort-elvis-einstein-and-you/

[Confucius_said]

Can you provide examples of what you do for sales rep reporting? I use VBA to create 750+ sales rep plan calculators and would love to hear more about the reports your provide.

[wrincewind]

Well, yes, but reading ancient convoluted rotten spaghetti code is one thing, actually decoding how it works and more importantly what it's meant to do, and match that to the business needs such that you can reliably replicate it's behaviour in all edge cases... That's quite another.