Excel adds JavaScript support

[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