• 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.

    • 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.

    • 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.

    • 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…