Missing Covid-19 test data was caused by the ill-thought-out use of Excel

Re:Missing Covid-19 test data was caused by the ill-thought-... by willtim on Monday October 05, 2020 @03:40PM (#24691225)

Yes and "on error resume next" is what I usually see in VBA code

[ Parent | on HN ]

Re:Missing Covid-19 test data was caused by the ill-thought-... by alexbrower on Tuesday October 06, 2020 @01:56AM (#24695077)

Curious, in what context are you all still using VBA?

[ Parent | on HN ]

Re:Missing Covid-19 test data was caused by the ill-thought-... by willtim on Tuesday October 06, 2020 @03:29AM (#24695467)

I, personally, wouldn't use VBA at all, ever. I would only consider Excel and Word for very simple use cases. For example, I refuse to use Word for technical documentation. But Office and Excel are everywhere in large corporates; and simple tactical spreadsheets turn into monsters over time. One former employer had a spreadsheet "application" where triggering a sheet recalc (accidentally) would take out an entire grid of machines. I've never been in any position to stop this stuff from happening.

[ Parent | on HN ]