PDA

View Full Version : Difference between vba/vb.net/



SUJU
10-21-2004, 11:05 PM
Hi
I would like to know the difference between vba; vb.net; microsoft.net;
visual studio.net.
Can one migrate from vba to vb.net.

Thanx

Howard Kaikow
10-22-2004, 06:14 AM
Hi
I would like to know the difference between vba; vb.net; microsoft.net;
visual studio.net.
Can one migrate from vba to vb.net.

ThanxVBA is the macro programming language used by Office since Office 97.
VBA is essentially a core subset of VB, with few differences, plus support for an application specific object model for each Office application.

VB .NET is one of several languages that are supported by NS .NET.

Currently, VB .NET cannot be used to write Office macros.

VSTO (Visual Studio Tools for Office) facilitates using VB .NET and C# with Word and Excel in Office 2003, but still MUST use VBA to actually write Word/Excel nacros.

XL-Dennis
10-22-2004, 07:50 AM
VBA is the macro programming language used by Office since Office 97.
If i recall it right VBA was introduced in Office 95, i e version 5.0, where we also had the possibility to program in local languages (among other languages Swedish!) and not only in english.
AFAIK, the term Microsoft.Net does not exist. Perhaps You mean Microsoft.NET Framework.

Howard Kaikow
10-22-2004, 09:02 AM
If i recall it right VBA was introduced in Office 95, i e version 5.0, where we also had the possibility to program in local languages (among other languages Swedish!) and not only in english.
AFAIK, the term Microsoft.Net does not exist. Perhaps You mean Microsoft.NET Framework.
VBA was first used in Excel in Office 95, but was not used in the other apps until Office 97.