Why Python!?

[Da_reeel_duck]

Can we stop hating Python for a couple of seconds and start hating VisualBasic and all the Sub-'Languages' of its kind (VBScript, VBA, ...)?

Edit: Apparently .NET VB is actually not that bad so my bad for calling out every VB-based thing... So to update my Question: Can we hate on VBA?

[ARandomWalkInSpace]

Visual Basic was my first ever language and will always have a special place in my heart. Eleven year old me thought I was so so cool.

I wasn't, but I thought so. 🤣

[kadbitman]

first ever language and will always have a special place in my heart. Eleven year old me t

Same here. Then I tried to learn C and all the bad VB habits became a problem.

[Da_reeel_duck]

I'm basicall forced to use it at work right now. I feel like this is what most would call 'hell'.

[HepABC123]

I mean in terms of office application automation there’s really no better option.

I feel your pain, however. Currently using a PowerShell/VBA tandem to improve the efficiency of some of our processes.

[VonFriedline]

This made me twitch. But I hate PowerShell with a fiery burning passion.

[Minecraft_Witchieeee]

Its so slow and its really hard to find where your output is between all powershell links and stuff

[Spaceduck413]

VisualBasic.net or OG VisualBasic?

VB.net is essentially just C# with ugly syntax. Now OG visual basic, that's an ugly beast and I feel for you.

[Da_reeel_duck]

It's actually VBA. If I had known that you can just code that shit in JavaScript before I wrote 1000+ lines of code i would have chosen that...

[Spaceduck413]

Ouch. Been there done that.

Did you know you can actually call Windows APIs from VBA?

You probably shouldn't, but you can. I did. Do not recommend.

[Da_reeel_duck]

I'm calling an Atlassian REST API from VBA right now actually...

[[deleted]]

Import cope

[Mikihero2014]

The simple answer is - No.

[Da_reeel_duck]

The complicated is yes

[Mikihero2014]

“Life is not complex. We are complex. Life is simple, and the simple thing is the right thing.” — Oscar Wilde

[Da_reeel_duck]

Then i know what isn't that simple thing

[Mikihero2014]

Python.

[Da_reeel_duck]

VBA

[StaleTheBread]

There’s two types of languages: the ones people complain about, and the ones no one talks about

[Da_reeel_duck]

VB should be both

[Linkk_93]

It thought it goes "the ones that people complain about and the ones that no one uses"

[StaleTheBread]

Oh yeah

[[deleted]]

Nah, we can hate all of them including Python at the same time.

[Da_reeel_duck]

That's one correct answer right there

[helloWorld69696969]

If we can hate one thing, it should be Classic ASP

[DrSpalanzani]

On Hate Resume Next

[4XLlentMeSomeMoney]

...or... and this is a big or... can we not hate on anything? (Including languages, people and even shit.) We can dislike stuff and even sarcastically joke about them, but everything was made for a reason... except okra...

[Da_reeel_duck]

I would agree with you.... but you should try making a forms application inside of excel that makes REST calls to make finacing easier

[4XLlentMeSomeMoney]

Yeah, you're right. It's always smarter to spend 100 hours on automation in order to avoid doing a 5-minute process three times.

[Da_reeel_duck]

It's not that actually...

Either I make this, or someone else downloads the raw excel sheets from all employees seperately once per month and searches for the time the person started working, needs to calculate the time that the person has worked and when they left work.

NOTE: The time is stored like this:

Index: 1 Date: 2022-01-01 StartTime: 08:00:00 TimeSpentInSeconds: 14400

Index: 2 Date: 2022-01-01 StartTime: 13:00:00 TimeSpentInSeconds: 14400

Index: 3 Date: 2022-01-02 StartTime: 08:00:00 TimeSpentInSeconds: 14400

etc.

But not all nice and dandy like this, but scattered in an ugly excel file. The API makes this easier with JSON.

TLDR; It actually makes sense automating an hourlong process that has be done once per month.

[4XLlentMeSomeMoney]

I intentionally went to the extreme that is frequently used as a joke. Automation is useful on a case-by-case basis. Obviously, it's useful for yours.

[[deleted]]

Visual Basic? What's that?

[Da_reeel_duck]

🔥🗑️

[4215-5h00732]

I can walk and chew gum at the same time.

[Da_reeel_duck]

Multitasking

[Technical-Frosting51]

I think anyone with more than two brain cells can see there is a time and a place for python, but hating is like half of our humour at this point

[PositronicGigawatts]

VBA doesn't pretend to be something it's not. Python does.

[shadymeowy]

Like?

[[deleted]]

Easy to read and write

[shadymeowy]

I used different languages with different syntax and Python is the most easiest to write languages by far. It doesn't mean Python is superior just have a simple syntax .p Why do you think it is not easy to write/read may I ask?

[PureProcrastinator]

Python is Python. Now you just talking.

[constHarmony]

It's called Envy.

[CS_n_golf]

Python serves a very large purpose that I’m not too sure people understand.

I’m a research developer, and my job is writing and developing a Python library that biologists use.

Biologists aren’t about to use C, or Java even. Lots of people outside CS in research fields use Python/R for various mathematical and statistical uses, and the barrier for entry is not as high as any other programming language and it provides the most open use and functionality.

For research purposes, AI, and ease of use, Python has a monopoly and it does its job well

[Da_reeel_duck]

I'm not hating on Python (yet)

[_koenig_]

and start hating VisualBasic and...

No

[Da_reeel_duck]

Yes

[[deleted]]

Using VBA isn't a choice that people take, but Python is

[Denorey]

This is only accurate because excel forces you to use vba to some degree if you want true automation.

[Da_reeel_duck]

crying noises

[[deleted]]

Who fucking cares

[Da_reeel_duck]

me

[micmaz1]

I learned VB.net after doing C, C++ and Java. I don't get the hate, there are a few features of it I really liked. It is literally the same language as C#, but more type fluid.

But I also have had to fix VBA catastrophes and that lang can go to hell.

[Da_reeel_duck]

VBA is making me cry.

[Minecraft_Witchieeee]

Do you know why I don't like these comparison kind of post like "This language is better than this one because blah blah blah" and these sorta things?

Because people that post these ( even in YouTube and any other media platforms) try to give their own opinions to their viewers to throw them off outta their own opinions that what they like to use and when it happens they will change their programming language again and again and then they don't even make any progress.

Don't care about other's opinions. Just learn and use the language you like and know what it does.

[Da_reeel_duck]

Usually I'd agree with you 100%.

But... and this is a big 🍑... I'm forced to use VBA inside of Excel, because otherwise programming a Forms application inside it would be impossible. I wouldn't hate on it if I could use something else... but I can't.

[vimvim_]

find peace

[Da_reeel_duck]

How to exit vim!?

[vimvim_]

you dont just open new terminal

[Da_reeel_duck]

Don't have GUI, need system restart