Click here to Skip to main content
14,869,589 members

Welcome to the Lounge

   

For discussing anything related to a software developer's life but is not for programming questions. Got a programming question?

The Lounge is rated Safe For Work. If you're about to post something inappropriate for a shared office environment, then don't post it. No ads, no abuse, and no programming questions. Trolling, (political, climate, religious or whatever) will result in your account being removed.
 
GeneralRe: The unfortunate VB & the fortunate Python? Pin
F-ES Sitecore26-Feb-19 3:23
mveF-ES Sitecore26-Feb-19 3:23 
GeneralRe: The unfortunate VB & the fortunate Python? Pin
Eddy Vluggen26-Feb-19 3:30
professionalEddy Vluggen26-Feb-19 3:30 
GeneralRe: The unfortunate VB & the fortunate Python? Pin
F-ES Sitecore26-Feb-19 3:51
mveF-ES Sitecore26-Feb-19 3:51 
GeneralRe: The unfortunate VB & the fortunate Python? Pin
jsc4226-Feb-19 2:47
professionaljsc4226-Feb-19 2:47 
GeneralRe: The unfortunate VB & the fortunate Python? Pin
F-ES Sitecore26-Feb-19 3:25
mveF-ES Sitecore26-Feb-19 3:25 
GeneralRe: The unfortunate VB & the fortunate Python? Pin
Johnny J.26-Feb-19 3:46
professionalJohnny J.26-Feb-19 3:46 
GeneralRe: The unfortunate VB & the fortunate Python? Pin
F-ES Sitecore26-Feb-19 3:57
mveF-ES Sitecore26-Feb-19 3:57 
GeneralRe: The unfortunate VB & the fortunate Python? Pin
Johnny J.26-Feb-19 4:14
professionalJohnny J.26-Feb-19 4:14 
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?!?!? Dead | X|

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??? D'Oh! | :doh:
Anything that is unrelated to elephants is irrelephant
Anonymous
-
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.
Mark Twain


modified 26-Feb-19 10:27am.

GeneralRe: The unfortunate VB & the fortunate Python? Pin
F-ES Sitecore26-Feb-19 4:34
mveF-ES Sitecore26-Feb-19 4:34 
GeneralRe: The unfortunate VB & the fortunate Python? Pin
Johnny J.26-Feb-19 4:44
professionalJohnny J.26-Feb-19 4:44 
GeneralRe: The unfortunate VB & the fortunate Python? Pin
F-ES Sitecore26-Feb-19 4:55
mveF-ES Sitecore26-Feb-19 4:55 
GeneralRe: The unfortunate VB & the fortunate Python? Pin
Johnny J.26-Feb-19 5:01
professionalJohnny J.26-Feb-19 5:01 
GeneralRe: The unfortunate VB & the fortunate Python? Pin
F-ES Sitecore26-Feb-19 5:06
mveF-ES Sitecore26-Feb-19 5:06 
GeneralRe: The unfortunate VB & the fortunate Python? Pin
Johnny J.26-Feb-19 5:08
professionalJohnny J.26-Feb-19 5:08 
GeneralRe: The unfortunate VB & the fortunate Python? Pin
den2k8826-Feb-19 2:51
professionalden2k8826-Feb-19 2:51 
GeneralRe: The unfortunate VB & the fortunate Python? Pin
Slacker00726-Feb-19 2:21
professionalSlacker00726-Feb-19 2:21 
GeneralRe: The unfortunate VB & the fortunate Python? Pin
Member 798912226-Feb-19 23:16
MemberMember 798912226-Feb-19 23:16 
GeneralJust nipping out for a smoke. Pin
Munchies_Matt25-Feb-19 23:34
MemberMunchies_Matt25-Feb-19 23:34 
GeneralRe: Just nipping out for a smoke. Pin
Kornfeld Eliyahu Peter25-Feb-19 23:45
professionalKornfeld Eliyahu Peter25-Feb-19 23:45 
GeneralRe: Just nipping out for a smoke. Pin
Munchies_Matt25-Feb-19 23:49
MemberMunchies_Matt25-Feb-19 23:49 
GeneralRe: Just nipping out for a smoke. Pin
OriginalGriff26-Feb-19 0:06
mveOriginalGriff26-Feb-19 0:06 
GeneralOT Pin
Johnny J.26-Feb-19 0:20
professionalJohnny J.26-Feb-19 0:20 
GeneralRe: OT Pin
Munchies_Matt26-Feb-19 0:33
MemberMunchies_Matt26-Feb-19 0:33 
GeneralRe: OT Pin
Johnny J.26-Feb-19 0:57
professionalJohnny J.26-Feb-19 0:57 
GeneralRe: OT Pin
Munchies_Matt26-Feb-19 1:13
MemberMunchies_Matt26-Feb-19 1:13 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.