3 ms·
Writing VBA code for users that can't is part of my everyday job, and I guess that it is the job of a lot of support/commando developers. Excel is a great tool
by zrz 13y ago
Writing VBA code for users that can't is part of my everyday job, and I guess that it is the job of a lot of support/commando developers. Excel is a great tool foto implement simple investment strategies but it often ends like 'hey could you write what we are trying to do in VBA ?', and most of the time it can be done. But I have that feeling that writing VBA costs more than it should, that VBA is playing against the developer while any other language makes him feel like there's no limits.
- gruseom 13y agoWhat 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.