3 ms·

What is a "better" solution? If a macro-programmed office document is doing its job, what constitutes "better"?

• endorphone 9y ago
  Why scarequote better twice? It is possible, you understand, for some solutions to be better than others. In 2017 there are shockingly few cases where macro programming an Office document is an ideal solution, and it is usually a really clear sign that you're approaching the problem wrong. It was seldom a good solution even in 2010. It's funny that in these conversations people always bring up finance. I work in finance, for a wide variety of companies making a wide variety of solutions. Excel automation is a curse. Every Excel automation is an abomination from a decade plus earlier -- islands of data, extraordinarily full of errors, security nightmares, data exposure risks, and on and on.
  • cmiles74 9y ago
    This. I don't think those automated Excel spreadsheets are doing as great a job as people think. Every time I've been brought in to try and migrate people away from these kind of solutions, we've exposed many bugs. Some not a big deal, others costing the company real money.