3 ms·
What kinds of things are they trying to do that you end up implementing in VBA for them? Do you ever have the feeling that some of these things ought to be doab
by gruseom 13y ago
What kinds of things are they trying to do that you end up implementing in VBA for them? Do you ever have the feeling that some of these things ought to be doable in Excel without having to resort to VBA?
(I ask because I'm working on a product in this space.)
- zrz 13y agoMostly functions that could be achieved with Excel formulas, but would require to add some more columns. As we are already struggling with file size, we often go with VBA implementation. I'm talking about calculating things like drawdowns in series, and other timeseries properties. We compared both implementation (Formulas ad VBA) and most of the time, VBA is several times faster, and reduces chances of application freeze; So we are not even discussing the need for VBA in the team.