VBA is the built in macro language for Office products. It's very powerful
and using automation you can control anything in any other Office
application. VB.Net is a standalone application that creates managed code
and any sort of application you like. It's much more of a professional
developers tool. It too can control any Office application via automation.
In fact it is easier and quicker to develop automation code in vb.net than
C# or any of the other .net languages.
Thanks for that useful distinction between VBA and VB.Net, but I also keep
coming across mentions of COM and VB6 in this discussion group so where do
they fit into the picture?
COM is about inter-program activities, Automation being one of them. Not an
accurate description but enough for now. VB6 is old VB now superseded by
VB.Net.
To begin with focus on developing in VBA. You can automate anything in
Project effectively without knowing how VBA can do it anyway.
COM is about inter-program activities, Automation being one of them. Not an
accurate description but enough for now. VB6 is old VB now superseded by
VB.Net.
To begin with focus on developing in VBA. You can automate anything in
Project effectively without knowing how VBA can do it anyway.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
