4 ms·

I spent a big part of my early career automating Excel, initially via VBA, then Interop (.net), then later via the OpenXML libraries. I actually really enjoyed

by jmkni 5y ago

I spent a big part of my early career automating Excel, initially via VBA, then Interop (.net), then later via the OpenXML libraries. I actually really enjoyed it, there's something a bit magical about taking a task that takes somebody hours to do, and putting it under a single button press, or even running it overnight and having everything ready for them when they start work the next day.

Martyrred 5y ago
That's what I'm doing right now. The company I'm at had this process for doing salespersons commissions that would take days to do. It was painful to watch the process the first time I was trained on it. They were sorting rows manually in excel, exporting csv's from the ERP software. Over a couple of months I worked automation into the project using SQL queries and vba/python, I even automated sending out all the personalized reports to each salesperson. Showed it to my boss last week (he had to run the reports this month) and he was blown away by how much time and energy it saved. It felt so good to reduce a process that took days to do down to a couple of button clicks.
- jmkni 5y ago
  Class :)