Comment on Microsoft to kill off VBScript in Windows to block malware delivery
macallik@kbin.social 1 year agoAt my old job, we had a VBA script that would:
- Pull company data from SQL
- Load data into an Excel file
- Update charts and KPIs
- Copy/Paste chart and KPIs into PowerPoint
- Switch to the next client
- Repeat all steps
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 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.