this post was submitted on 11 Oct 2023
439 points (98.9% liked)

Technology

59030 readers
3053 users here now

This is a most excellent place for technology news and articles.

Our Rules

  1. Follow the lemmy.world rules.
  2. Only tech related content.
  3. Be excellent to each another!
  4. Mod approved content bots can post up to 10 articles per day.
  5. Threads asking for personal tech support may be deleted.
  6. Politics threads may be removed.
  7. No memes allowed as posts, OK to post as comments.
  8. Only approved bots from the list below, to ask if your bot can be added please contact us.
  9. Check for duplicates before posting, duplicates may be removed

Approved Bots

founded 1 year ago
MODERATORS
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
439
Microsoft to kill off VBScript in Windows to block malware delivery (www.bleepingcomputer.com)
submitted 1 year ago by [email protected] to c/[email protected]
84 comments fedilink hide all child comments
you are viewing a single comment's thread
view the rest of the comments
[โ€“] [email protected] 15 points 1 year ago* (last edited 1 year ago) (1 children)

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

[โ€“] [email protected] 1 points 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.