3 ms·
It's a great idea, but I've been working in multiple enterprise excel hells and most of the places use macros, because the simple stuff just does not allow need
by ainla 12y ago
It's a great idea, but I've been working in multiple enterprise excel hells and most of the places use macros, because the simple stuff just does not allow needed complexity.
Now try to visualize that...
- f292 12y agoWhat we have found is that one of the biggest problems in the BI space is the fact people are not able to code and resort to some of the horrific formulae we see. But agreed - including macros would add a huge new layer of complexity!
- rahimnathwani 12y agoI much prefer reading Excel spreadsheet with complex formulae, than those with complex macros. It's much easier to follow things around and literally 'see' what's going on. Parentheses FTW!
- robzyb 12y agoAbsolutely! Also, the people who write macros are invariably not programmers[1], and the macro code they write is... not so great. [1] I am a programmer who writes macros, and presumably there are others too.