Hello,
I've been reading some articles around the internet, and while I have found that MS Office 2010 will indeed support VBA, I have also found that Microsoft is no longer working on developing VBA any further. This leads me to beg the question, "Should I continue using VBA, or should I switch over to something else, such as VB.Net or VSTO?" I work for a large financial institution, and my job is to write macros, databases, etc that help automate the tasks we perform on a daily, monthly or quarterly basis. I'm wondering if I can write these macros using VB.Net or some other variation of VB, or even C++, and if so, what steps do I need to take in order to move into that direction? Mainly, how well do these other variations of VB integrate with MS Excel, Access, etc? I would consider myself an advance VBA programmer, and have begun studying C++. If making a switch will be beneficial, I need to know why so that I can present a case to my management team.
Thanks,
-Ryan
I've been reading some articles around the internet, and while I have found that MS Office 2010 will indeed support VBA, I have also found that Microsoft is no longer working on developing VBA any further. This leads me to beg the question, "Should I continue using VBA, or should I switch over to something else, such as VB.Net or VSTO?" I work for a large financial institution, and my job is to write macros, databases, etc that help automate the tasks we perform on a daily, monthly or quarterly basis. I'm wondering if I can write these macros using VB.Net or some other variation of VB, or even C++, and if so, what steps do I need to take in order to move into that direction? Mainly, how well do these other variations of VB integrate with MS Excel, Access, etc? I would consider myself an advance VBA programmer, and have begun studying C++. If making a switch will be beneficial, I need to know why so that I can present a case to my management team.
Thanks,
-Ryan