Agree with most of what everyone has said but it doesn't address the problem
that not all VB6/VBA programmers have the luxury of Visual studio proper.
Some System Accountants like myself have huge amounts of legacy database and
spreadsheet applications to maintain using any combination ADO, DAO, SQL and
VBA written by successive people who have been in the role. Sometimes some
accounting applications are very lacking in reports and are managed using MS
Access.
Despite all the above, people like me aren't given Visual Studio we have to
survive with IDE of MS office Apps. So my initial gripe was that even if I
wanted to learn VB.net I can't because it isn't made available to me. My
other gripe is a lot of people seem to think that all programmers are members
of the IT department. Not true either. This is obviously why Microsoft
peddles .Net office programming as a Visual Studio Add-on - but it's plain
ignorant to think MS office programmers are all strict IT people.
I want to learn .Net and I don't care if VBA is around for 5 or 10 years. I
still have 20 years before my retirement so I have to keep up to date for the
time being. Microsoft is abandonning those VBA programmers who only have the
office IDE as their staple programming tools and insulting them as if they
were lower class citizens to my way of thinking.
I'd be happy to fork out for .Net privately but I'm not the person I need to
convince - it's the employers who dictate what tools are given to their
programmers in the work environment.
That's enough of a screed from me for now