• HidingCat@kbin.social
    link
    fedilink
    arrow-up
    20
    ·
    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.

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

      They didn’t start out building an enterprise critical application, they normally started as some little script someone built to make their work faster. Then they shared it with the team, built more features, and 20 years later hundreds of staff are using it and if it dissappeared they would be screwed.

      Plus the data in them is often the only record of critical data (in their defense, the spreadsheets are typically stored somewhere where the backup process will back them up).

      • cm0002@lemmy.world
        link
        fedilink
        English
        arrow-up
        13
        ·
        1 year ago

        they normally started as some little script someone built to make their work faster.

        It’s me, I’m that guy lmfao, although by the time I left it was considerably more complex. I have “real” languages under my belt, but it was a banking environment and VBA was all I had (Which even that kinda surprised me lol).

        I was hooked into the windows API and doing all sorts of stuff and yea before leaving I did distribute stand alone parts of it (The full system was a beast, 90% of my job was automated towards the end lololol)

        Honestly, VBA is more powerful than people give it credit for, just a PITA to implement some things

    • macallik@kbin.social
      link
      fedilink
      arrow-up
      15
      ·
      edit-2
      1 year ago

      At my old job, we had a VBA script that would:

      1. Pull client data from SQL
      2. Load data into an Excel file
      3. Update charts and KPIs
      4. Copy/Paste chart and KPIs into PowerPoint
      5. Switch to the next client
      6. Repeat steps 1-5 for +100 clients

      Thirty page custom reports per client within 2 minutes (when nothing broke). It allows you to interact and automate across the Microsoft Suite. That is one of the reasons why it is indispensable to many companies

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

        This is definitely giving me flashbacks during my time in the corporate world. There was one report that was replete with copy and pasting, the poor lady who used to do it apparently had to pull all-nighters doing it. I rebuilt everything in Access using some SQL and the new process only took 15 minutes to run.

    • kubica@kbin.social
      link
      fedilink
      arrow-up
      14
      ·
      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
        1
        ·
        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
          3
          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
      13
      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.

      • mosiacmango@lemm.ee
        link
        fedilink
        English
        arrow-up
        4
        arrow-down
        1
        ·
        1 year ago

        They have an alternative called Powershell that can do what VBS does and more. Its a modern and actively developed scripting language that Microsoft undoubtedly expect you to port your code into, that is if you cant use a cloud product first wink wink

        It will be a shit show of course, at least for those orgs that dont block this depreciation outright via whatever method comes out. Still, there is putty to patch the holes.

    • I_Miss_Daniel@kbin.social
      link
      fedilink
      arrow-up
      5
      ·
      1 year ago

      I suppose Microsoft Access has better options now you can define the steps in macros, but I think it’s still needed for many of the more fiddly bits.

    • Lee Duna@lemmy.nzOP
      link
      fedilink
      English
      arrow-up
      4
      ·
      edit-2
      1 year ago

      Yup, I was the guy who wrote vba script to calculate performance of network mobile and export chart to ppt files.

      Many critcal engineering and financial calculations rely on vba scripts