I'm no authority on programming matters but I've learned a few things about it (and more so, myself).
I gave up on Excel as the error detection was difficult for anything more complex than straightforward grids was cumbersome, I've become allergic to GUIs as well. That said I still use Excel for one-off tasks or something very rarely used.
For other things, I try to program as much as possible even if it takes more time because I learn things and become more comfortable with the language, in the end it might be faster than filling the grid in Excel.
I can't agree that eliminating bugs related to automation is easy for a professional either. Many of the bugs I've encountered are one-off instances, from changes in software (APIs) or changing regulations or network issues. I can't imagine how I could've prepared for all these problems. Many won't be obvious until many months after the initial run.
Using Notepad++ / geany, as IDEs often hides the complexity one really should want to avoid. If programming is a messy chore, it's not fun. Clear syntax highlighting and black background can go a long way.
Excel is great for aggregating few numbers, but not worth doing anything complicated in (ie. non-linear stuff), that isn't already prepackaged. Excel is great for prototyping simple stuff and VBA can offer some aid what declarative formulas won't provide, but it's truly amazing what the formulas can do really.
Learning can be fun, so good stuff.
The general professional environment for past 20+ years doesn't really provide a good environment for good design & code unfortunately, though depending where you are and how much autonomy you get. API-changes and network issues can be seen as "other people's code", and why many want to go back to simplicity, a UNIX-style philosophy where each tool does one or few bounded actions, and doesn't turn into huge warty monsters over time.
However, bugs aren't evil: They keep people busy maintaining code, sparking new ideas, and is often an accepted business risk. Otherwise businesses would work to iron them out much more, and be much more reluctant to change everything to alienate their users and employees.
Preference may be king though, as it doesn't make sense to do what one doesn't love to do. Doesn't mean there'll never be periods of grind on anything worthwhile, but that it should be worth it.
Last edited:
