Microsoft to kill off VBScript in Windows to block malware delivery - eviltoast
Microsoft is planning to phase out VBScript in future Windows releases after 30 years of use, making it an on-demand feature until it is removed.
  • macallik@kbin.social
    15·
    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
      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.