• funkless_eck@sh.itjust.works
    link
    fedilink
    English
    arrow-up
    70
    ·
    14 days ago

    I once made an xlsx with a VBA module and put it in my often-late coworkers’ startup folder. It would check log-on time and if it was between 9:01am and 9.59am it would send an email to the rest of the team apologizing for being late that day.

    Stunning that I could do that on what was supposedly a locked-down internal system.

    • CaptDust@sh.itjust.works
      link
      fedilink
      English
      arrow-up
      50
      ·
      edit-2
      13 days ago

      I once used VBA to script and automate 90% of my old desk job. I just needed a way to automate keyboard input and some basic conditional controls.

      I couldn’t install python or run batch scripts as the machine was heavily locked down, but luckily MS provided all the tools I needed inside excel. System admins hate this one trick, thanks microsoft!