Will VBA Die? (2019)

#1

Post by UkiahSmith » Thu, Feb 27, 2020, 11:11 PM UTC

Will VBA Die? (2019)
thespreadsheetguru.com

Re: Will VBA Die? (2019)

#2

Post by tombert » Thu, Feb 27, 2020, 11:16 PM UTC

I don't own a Windows computer, but I've seen some incredibly interesting stuff come out of the VBA for Excel, which I sadly never have had a chance to learn.

Does anyone here have a side-by-side comparison of the LibreOffice BASIC vs the VBA?

Re: Will VBA Die? (2019)

#3

Post by grma1 » Thu, Feb 27, 2020, 11:22 PM UTC

this will definitely will be a huge relief for many sys-admins in windows environments... I think javascript isn't a bad choice since ms isn't as ignorant as some years ago, when it comes to new standards.

Re: Will VBA Die? (2019)

#4

Post by ShakataGaNai » Thu, Feb 27, 2020, 11:25 PM UTC

As it is 2020 and VBA still exists. No.

Re: Will VBA Die? (2019)

#5

Post by pgt » Thu, Feb 27, 2020, 11:26 PM UTC

Betteridge’s Law says no.

Re: Will VBA Die? (2019)

#6

Post by HenryKissinger » Thu, Feb 27, 2020, 11:29 PM UTC

As long as Excel is used by businesses, VBA will be relevant. Excel will probably continue to exist - and be supported and updated to ever newer versions - forever, so it stands to reason that VBA will probably also exist forever. Unless Microsoft goes bankrupt and Excel isn't picked up by another company. Which will also probably never happen.

Re: Will VBA Die? (2019)

#7

Post by codegeek » Thu, Feb 27, 2020, 11:34 PM UTC

If traders/quants and financial analysts in banks say that they don't need VBA anymore, sure it will die. Otherwise, not a chance. Trust me.

Re: Will VBA Die? (2019)

#8

Post by phendrenad2 » Thu, Feb 27, 2020, 11:36 PM UTC

Hopefully not. It's withstood the test of time, why replace it with something trendy?

Edit: Yes, Python has also withstood the test of time... as a scientific and web language. There's no reason to assume that it could replace VBA as a spreadsheet automation language used by relatively non-technical business folks.

Re: Will VBA Die? (2019)

#9

Post by wolrah » Thu, Feb 27, 2020, 11:37 PM UTC

If there's one thing I've learned in 15 years of IT work, it's that once business users have discovered a thing it will never die.

No matter how outdated, shitty, useless, etc. it may be, some jackass has built their entire workflow around it and has more power than you to prevent that from ever changing.

Re: Will VBA Die? (2019)

#10

Post by chaostheory » Thu, Feb 27, 2020, 11:37 PM UTC

HenryKissinger wrote: post #6

As long as Excel is used by businesses, VBA will be relevant. Excel will probably continue to exist - and be supported and updated to ever newer versions - forever, so it stands to reason that VBA will probably also exist forever. Unless Microsoft goes bankrupt and Excel isn't picked up by another company. Which will also probably never happen.

Microsoft is slowly transitioning Excel macros to Javascript / Typescript. It will happen eventually.