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