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