• Dave@lemmy.nz
      link
      fedilink
      English
      arrow-up
      0
      ·
      1 year ago

      I have seen critical enterprise applications run in VBA in excel. Removing VBA would cause global economic ruin. I’m pretty sure that’s the unspoken backstory for the Fallout series.

      • eee@lemm.ee
        link
        fedilink
        English
        arrow-up
        0
        ·
        1 year ago

        Well it’s gotta be done some time… otherwise we end up with another version of COBOL.

        • Melkath@kbin.social
          link
          fedilink
          arrow-up
          0
          arrow-down
          1
          ·
          1 year ago

          Or how about this… we use what works and stop throwing the world into chaos every 4 years so Microsoft can sell their next 50k/year enterprise application.

      • OldFartPhil@lemm.ee
        link
        fedilink
        English
        arrow-up
        0
        ·
        edit-2
        1 year ago

        Another confirmation here. At my previous job, I was they guy who built Access databases and wrote VBA code. While not ideal, it was a very small business (less than 10 employees) and it was fit for purpose.

        When I got a new job at a company with almost 3,000 employees, I was like, “Finally, I’ll be working somewhere that has proper IT resources.” Ha! I soon find out that my department runs critical business infrastructure with Excel macros. And we have a proper IT department.

        As everyone has already said, if IT resources are in short supply (or the wait is too long, or building projects with IT support is a PITA), then people will build systems with the tools they have at hand. And that’s often MS Office.

        • BoofStroke@lemm.ee
          link
          fedilink
          English
          arrow-up
          0
          ·
          1 year ago

          IT isn’t developers. What is really needed is a developer on your team, or somebody who at least knows how to lead the effort. I’ve been that guy.

          • OldFartPhil@lemm.ee
            link
            fedilink
            English
            arrow-up
            0
            ·
            1 year ago

            We do have developers on our team. They write Excel macros :). I work in data integration, so it isn’t as simple as building a more robust tool. We still need infrastructure support or our tool doesn’t do anything.

            • Melkath@kbin.social
              link
              fedilink
              arrow-up
              0
              arrow-down
              1
              ·
              1 year ago

              Please at least tell me that the Macros are just a front end for ODBC connections to actual SQL servers for ETL functions, and it ALL isn’t stored only in excel…?

        • Melkath@kbin.social
          link
          fedilink
          arrow-up
          0
          arrow-down
          1
          ·
          1 year ago

          Also remember, strictly speaking, IT is not software development. IT is networking and hardware management.

          Software development (and scoff all you want, but VBS/VBA are programming languages/frameworks used to develop software applications) is its own separate beast.

          They MAY report to the CIO. They could also report to the COO. Fuck, software development/process automation/business intelligence can have a director reporting directly to the CEO.

          In general, software development and information technology are not the same and don’t reside in the same chain of command.

      • HidingCat@kbin.social
        link
        fedilink
        arrow-up
        0
        ·
        1 year ago

        WTF, seriously? VBA feels more like a scripting addon (which I suppose it is), not something to build wholesale CRITICAL programs with.

        • kubica@kbin.social
          link
          fedilink
          arrow-up
          0
          ·
          1 year ago

          The things done in excel might not be critical per-se, but macros are used and abused a lot and many companies can be affected by their dependence on workflows refined over the years.

          • HidingCat@kbin.social
            link
            fedilink
            arrow-up
            0
            ·
            1 year ago

            Haha, don’t I know it. I’ve had to work with some of them in a past life. Messy and also very scary at how they underpin million dollar decisions.

            • Melkath@kbin.social
              link
              fedilink
              arrow-up
              0
              arrow-down
              1
              ·
              1 year ago

              This is true for software in general.

              The same description can be given to workshops (and you know they already exist) that do the same stuff with ChatGPT.

        • Melkath@kbin.social
          link
          fedilink
          arrow-up
          0
          arrow-down
          1
          ·
          1 year ago

          It’s a scripting language.

          A solid, verbose, diverse scripting language that gives you impressive control over Windows environments.

          If some people are delivering malware or phishing, that sucks, but it doesn’t negate the languages merit.

          It would be the same as ceasing production of spray paint because of taggers.

          The ends don’t justify the means.

      • Melkath@kbin.social
        link
        fedilink
        arrow-up
        0
        arrow-down
        1
        ·
        1 year ago

        My job is literally to keep a NASDAQ company afloat on process automation written mostly in VBA to make up for the sweeping layoffs that were made to keep the CEOs bonuses fat…

      • AlmightySnoo 🐢🇮🇱🇺🇦@lemmy.world
        link
        fedilink
        English
        arrow-up
        0
        ·
        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).

        • Melkath@kbin.social
          link
          fedilink
          arrow-up
          0
          arrow-down
          1
          ·
          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.

          • Neshura@bookwormstory.social
            link
            fedilink
            English
            arrow-up
            0
            ·
            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.

            • Melkath@kbin.social
              link
              fedilink
              arrow-up
              0
              arrow-down
              1
              ·
              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.

              • Neshura@bookwormstory.social
                link
                fedilink
                English
                arrow-up
                0
                ·
                1 year ago

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

                Not trying to hate on you but this sort of take is really bad. I understand if you dislike programming and are forced to do it for your job but otherwise learning a new thing occasionally is a good thing. In case programming is a key part of your job it’s like a carpenter saying “I prefer hand sawing everything but if they discontinue them I’ll be forced to use a table saw”. But again, if you are forced to program at work despite not liking it that changes things.

                • Melkath@kbin.social
                  link
                  fedilink
                  arrow-up
                  0
                  arrow-down
                  1
                  ·
                  1 year ago

                  I challenge your read.

                  I love programming. I’d love to expand my knowledge.

                  I am 5 years deep on “you hired an analyst and then demanded a developer/architect/salesman, and the payrate didn’t follow. I am still making creative ramen dishes from my rental when I should have a house, and I should get a yearly vacation.”

                  My CEO gets 30% gains yearly… and he is the only person at my company that enjoys that.

                  Basically I am striking. Like the rest of the world.

                  Cool you are making a fair wage and aren’t scabbing on your peers. Because a love for leaving behind what works to make something in a different language that also works fills your soul with joy?

                  • Neshura@bookwormstory.social
                    link
                    fedilink
                    English
                    arrow-up
                    0
                    ·
                    1 year ago

                    Because a love for leaving behind what works to make something in a different language that also works fills your soul with joy?

                    Yes? I don’t know what you expect me to say here, why tf wouldn’t learning a better language every now and then fill me with joy? I’m dabbling in side projects all the time and when I switched from React to Svelte I felt elated because it’s just so much more comfortable to work with. If your boss is not paying you for your work that’s that but nothing stops you from learning new stuff for yourself. I do understand you not wanting to hand your boss your training for free but nobody forces you to do that either, just don’t mention that you can use python when asked. That simple.