Relationship between VBA, VB.Net and COM?

G

Graham944

Can someone please point me at a reference explaining the relationship
between VBA, VB.Net and COM?

Thanks,

Graham.
 
R

Rod Gill

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.
 
G

Graham944

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?

Graham.
 
R

Rod Gill

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.
 
G

Graham944

That's great thanks.

Graham.

Rod Gill said:
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.

--

Rod Gill
Project MVP
Visit www.msproject-systems.com for Project Companion Tools and more
Click to expand...
 
Top