Comment on Microsoft to kill off VBScript in Windows to block malware delivery

• AlmightySnoo@lemmy.world ⁨1⁩ ⁨year⁩ ago

  Yup that’s normal because VBA is single-threaded, doesn’t take advantage of vector instructions and even its interpreter is slow. So when someone writes numerical code in VBA working in single precision, and assuming they have an 8 core CPU with AVX2, they’re using only 1/64-th of their CPU’s processing power. On the other hand with Python, while it’s still interpreted, the interpreter is much faster on its own, and you have modules like numpy that use precompiled routines that take advantage of vector instructions (and possibly multiple cores).

  source

  • Melkath@kbin.social ⁨1⁩ ⁨year⁩ ago

    Yes. Python is a LOT more powerful. Requires a LOT technical knowledge to operate.

    Are you making north of 150k to make your strife worth it?

    Or are you raising the technical bar while also lowering the compensation bar?

    Myself, I make 60k and my VBA gets the job done. Zero incentive to get into the minutia you just explained. My shit works. And I'm not set on fucking up the bell curve for everyone.

    source

    • neshura@bookwormstory.social ⁨1⁩ ⁨year⁩ ago

      bruv Python is so simple you barely need to know English to use it. Haven’t used VBA but I’ll just blindly guess it’s more difficult because honestly I have not seen a language that is easier to pick up than Python.

      source

      • Melkath@kbin.social ⁨1⁩ ⁨year⁩ ago

        Well, if VBA disappears, Python is what I'll need to learn.

        If I don't need to learn a new language tho, I'd prefer that.

        Honestly, 95% of my vba is just nested do until loops.

        The remaining 5% is ODBC connections and BCP shell commands.

        source

        • -> View More Comments
      • TopRamenBinLaden@sh.itjust.works ⁨1⁩ ⁨year⁩ ago

        I learned some VB.net in college and it probably depends on what you are trying to do with it, but it’s simpler than Python, I would say. It is an event driven language, and you handle everything at a very high level. It was the first language taught in my CS studies in the mid to late 2000s for that reason.

        That being said, Python is very nice and intuitive to learn and work with as well. It’s just a much deeper rabbithole than VB.

        source
    • driving_crooner@lemmy.eco.br ⁨1⁩ ⁨year⁩ ago

      Python is way easy lo learn that VBA imo, and is way more useful.

      source
    • AlmightySnoo@lemmy.world ⁨1⁩ ⁨year⁩ ago

      I don’t know what your seniority is, but it’s cool if it works for you. However, to remain employable in case you someday get laid off (of course not wishing you that), it would be beneficial to have experience in a more modern language. To remain fixated on one single language/tech just because it works for you for now is going to cause you lots of pain in case you need to hit the job market again someday and it would be too late to learn new languages because, depending on your seniority again, recruiters won’t want someone who just began learning the language.

      source
• MonkderZweite@feddit.ch ⁨1⁩ ⁨year⁩ ago

  Btw, Libreoffice supports python scripts. Other offices too?

  source

  • lud@lemm.ee ⁨1⁩ ⁨year⁩ ago

    Excel will kinda support it soon, unfortunately it will only be available to run in the cloud and not locally.

    source
  • driving_crooner@lemmy.eco.br ⁨1⁩ ⁨year⁩ ago

    I work in corporate, so it’s Microsoft all the way up.

    source