DominiConnor
Quant Headhunter
- Joined
- 9/6/06
- Messages
- 1,051
- Points
- 93
On most of the popular tech websites there have been increasingly hysterical posts about Microsoft killing off VBA.
Although not loved by quants (or anyone else), VBA in Excel is the glue that holds together a large % of financial markets.
I always counsel newbies to get vaguely competent in VBA, because it allows them to demonstrate good visible productivity early in their careers. C++ might give you a better faster solution, but for some tasks VBA will do it sooner, which makes your peers and bosses think better of you.
Rest assured VBA is not dying. I have specifically had written confirmation of this from the product manager at Microsoft that it will be in at least the next version after 2007, which may or may not be 2009. Given that 90% of banks are on Excel versions that are 3-5 years old, it will be out there for a long time yet.
It's official now:
http://www.regdeveloper.co.uk/2008/01/21/vba_office_victory/
Although not loved by quants (or anyone else), VBA in Excel is the glue that holds together a large % of financial markets.
I always counsel newbies to get vaguely competent in VBA, because it allows them to demonstrate good visible productivity early in their careers. C++ might give you a better faster solution, but for some tasks VBA will do it sooner, which makes your peers and bosses think better of you.
Rest assured VBA is not dying. I have specifically had written confirmation of this from the product manager at Microsoft that it will be in at least the next version after 2007, which may or may not be 2009. Given that 90% of banks are on Excel versions that are 3-5 years old, it will be out there for a long time yet.
It's official now:
http://www.regdeveloper.co.uk/2008/01/21/vba_office_victory/