Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Visual Basic for Application same as Visual Basic 6 or .NET

Status
Not open for further replies.

WTT

Technical User
Jan 8, 2007
3
0
0
US
Hi,

Just wonder if Visual Basic for Application (VBA) provided in Microsoft Office is a totally new language, or the same as Visual Basic 6? or VB.NET?

Does VBA evolve in different versions of office, like VB did from 6 to .NET?
 
The VBA language is the same language as VB. Because it runs inside another application it does not need, nor have, the features related to stand-alone projects. Instead, VBA has direct access to the object model of the parent application. VB.Net is a little different although there are many similarities.

VBA versions more or less mirror VB versions. VBA version 6, introduced in Office 2000, is equivalent to VB6; the earlier VBA version 5 is similarly equivalent to VB5. There is no VBA.Net but VSTO (Visual Studio Tools for Office) is available if you have Visual Studio and I think (I haven't used it) it is .Net-like.

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.

Professional Office Developers Association
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top