turkishlurker | 2 years ago | on: Why do people still use VBA?
turkishlurker's comments
turkishlurker | 3 years ago | on: Shaving is an example of how consumer products extract more money
turkishlurker | 4 years ago | on: Why is it hard to buy things that work well?
turkishlurker | 4 years ago | on: Modeling chopping onions: The importance of mise en place
turkishlurker | 4 years ago | on: J. Kenji López-Alt says you’re cooking just fine
turkishlurker | 4 years ago | on: Brandon Sanderson’s advice for doing hard things
turkishlurker | 4 years ago | on: Ask HN: What is the most unique website you’ve come across on the internet?
turkishlurker | 4 years ago | on: In Search of Troy
a) I'd be forced to complete a painstaking task "manually", and likely committing the occasional error in the process, not to mention all the time I'd have "wasted"
b) In the case of "optional" tasks (whatever that may mean) I'd have had to give up on whatever functionality/feature VBA enables and some level of detail/sophistication/speed would thereby be lost.
To get a bit more concrete in terms of use cases, any spreadsheet task involving a bill of materials or having to do with stock management is probably ripe for some VBA enhancement. I am aware that it is looked down upon by some, but advising against VBA in favor of Python or some other "proper" tool that calls for an IDE is a bit like telling someone who wants to take up home cooking to get a fancy Japanese chef's knife set plus a sharpener instead of the good old all-purpose knife he is certain to have lying around.