F-ES Sitecore wrote:VBA is still used today, yes, that's why I said we still use VBA but not VB because that is a factually correct statement.
You're being inconsistent in your arguments. When we discuss VB, you say that you're talking about new developments, when we're talking about VBA, suddenly that's no longer the case.
However: VB as in "real" Visual Basic used for application development is still very much being used - even in new development projects. The fact you you claim it isn't doesn't make it any less true.
As for VBA: Yes, I'm sure that there is still people out there who still uses it, because they have old spread sheets or whatever with custom calculations and they are too stubborn or lazy or ignorant to upgrade their ancient solutions to 2019 equivalents.
As for your claim that you'd use if for building new scriptings in Word or Excel TODAY, I'd say that you'd be doing yourself and everybody a huge bear service. VBA may still exist in Office, but Microsoft is trying actively to dissuade the use of it.
Personally, I haven't used VBA for ANYTHING in more than 15 years, but as by a mere coincidence, this very morning I had an Excel task for which I thought it could be an idea to use VBA to solve it. What are the chances of such a coincidence? I don't know, but I feel like I must buy myself a lottery ticket on the way home.
So what happened? I coded a short code snippet for my task, and tried to save the file. BANG! First problem: You cannot save documents containing code in the "new" file format (xlsx, and I use "new" in the widest sence of the meaning since it's been around for 12 years now). So by simply using VBA, you're forced to save your document in a 12+ year old format?!?!?
I had to do it the ancient way like our ancestors and save it in the old xls format. And BANG! comes problem number two: Every time I have to open or save or actually do anything with this file, I get a Microsoft message saying that it contains contents that can cause incompatibilities or loss of data or whatever it says - because of the old file format!
At that time, I gave up and reverted to the newer version of the document WITHOUT any VBA customizations and I solved the problem in another way.
Hence my claim that VBA is dead, becuase even though it still exists, it's virtually unusable.
I also feel that you've taken crazy pills, and I can't really understand how anybody can be SO completely out of touch with reality???
Anything that is unrelated to elephants is irrelephant
The problem with quotes on the internet is that you can never tell if they're genuine
Winston Churchill, 1944
Never argue with a fool. Onlookers may not be able to tell the difference.
modified 26-Feb-19 10:27am.