2 ms·
> I would have never used Excel and macros as the tool to automate the things that I did, but these systems were completely locked down without the ability to i
by pessimizer 4y ago
> I would have never used Excel and macros as the tool to automate the things that I did, but these systems were completely locked down without the ability to install anything or use many online services.
I got good at VBA through this same situation. I had to do some very complex, auditable number crunching on systems that were completely locked down by the parent company of a subsidiary. Excel VBA worked kind of perfectly, because it generated exactly the kind of output that execs could understand, spreadsheets. I developed a style of working where my output looked like it was the tool i.e. I would put formulas in cells rather than hardcoding results in the output, so people could trace the calculations and play with them in the way they were used to.
It certainly wasn't because I loved VBA, I didn't even use Windows at home. I did end up affectionate for Excel, though. All of my personal programming was in functional Erlang at that time, and the idea of having the output of a ton of data processing be a set of spreadsheets that could be further worked with felt a lot like returning a function.
Two different companies I was contracting for asked me to do an Excel tricks presentation for their staff. It made me realize how many office drones are anxiously pretending to know how to use Excel, and that more offices should be giving basic Excel classes to general staff.