wilmott.com

hiI have been working with C++ for 1 year by now. And I have been enjoying it!I am currently working around with pricers in Quantlib after practicing Templates,STL & few design patternsAlso worked with DanielDuffy's codeNow , I have also picked up some VBA down the road (recording Macros, writing UDF & simple Subroutines etc.)But I dont find it exciting & useful the way C++ seems to be. For implementing simple algorithms, multiple SUBS are written. And the code seems quite cumbersume & no ObjecOriented support for code reuseSo, what is the advantage of VBA over C++ in quant work? Also, what are the types of tasks where VBA could be preferred over C++I am not sure if quants really use VBA for solving PDEs, heavy Monte Carlo runs etc.Still, the fact is recruiters consider VBA as an important skill.......to what extent??

VBA is mostly popular due to its connection to Excel, right?

yes....but C++ libraries are provided Excel interface .So what purpose VBA serves besides recording macros & some user defined functionsmaybe I am missing something about VBA!If one works with C++, does he need to keep improving VBA skills?especially for newbies, there is significant trade-off between the two

imagine i just asked you to build me a spreadsheet with a couple of special functions.how long is it going to take you to do it in VBA only, and then how long if the functions are written in c++? (imagine you have to do it before leaving the office, for example).and how many files are you going to have to send me in each case?the answers to these questions are one of the reasons VBA is so popular.then think about the thousands of guys in the city who want to do some fairly advanced spreadsheet work but because they dont work in IT they dont have any development software and their desktop is so locked down they cant even download something free from the web and work with that. these are the guys for whom VBA is indispensible.

patch22, outrunthat makes quite clearthanks!