|
||||
|
VB, VB.NET, VBA By Richard Rost Visual Basic vs. Visual Basic .NET vs. Visual Basic for Applications
A: Lou, VBA is a close cousin of VB, but it's not the same thing. You're talking about apples and oranges. I know the names sound the same, but they are completely different beasts. Basic has changed a lot over the past few decades. In fact, I started out programming on a TRS-80 Radio Shack computer back in the 1980s on one of the earliest versions of BASIC. Yes, it's an acronym. It stands for Beginners All-purpose Symbolic Instruction Code. It has evolved a lot since then...
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Feature | VB | VBA | VB.NET |
|---|---|---|---|
| Language Evolution | Legacy version of Visual Basic | Embedded in Microsoft Office apps | Modern, object-oriented version |
| Interoperability | Limited to Windows-based applications | Integrates with Office applications | Works with .NET framework, extensive interoperability |
| Runtime Environment | Standalone Windows applications | Runs within host applications (e.g., Excel, Access) | .NET framework, supports various platforms including web |
| Development Environment | Visual Basic development environment | Integrated into Office apps' environment | Visual Studio |
| Typical Use Cases | Desktop applications for Windows | Automation scripts within Office apps | Web services, web applications, desktop applications |
| Language Features | Procedural and object-based elements | Similar to VB6, tailored for automation | Fully object-oriented, supports advanced programming concepts like inheritance, threading |
| Updates and Support | Discontinued by Microsoft | Still supported within Office suite | Actively updated and supported by Microsoft |
There are also some 3rd-party Visual Basic-like programs available, like twinBasic. I may make tutorials for those too. Again, still in planning.
If you have a favorite version of Basic that you like, post a comment about it down below!
If you want to learn more about any of these topics, check out these links.
And of course if you have any questions, please post them below. Thanks.
LLAP
RR
Updated: April 2024
| Age | Subject | From | |
| 14 years | Where is all the action | Ron Oates | |
| 16 years | correct courses for me | Turnditch | |
| 16 years | VB | Ron Oates | |
| 18 years | No Subject | Chris Bezant | |
| 18 years | No Subject | Richard Rost | |
| 18 years | No Subject | Chris Bezant | |
|
| |||
| Keywords: vb vba access vb vs vba vb.net vbnet access vba vb6 vba vs vb vb vs vbnet PermaLink Visual Basic vs. Visual Basic .NET vs. Visual Basic for Applications |