• @DaveA
    link
    English
    318 months 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).

    • @[email protected]
      link
      fedilink
      English
      138 months 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