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
Printable View
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
VBA is the macro programming language used by Office since Office 97.Quote:
Originally Posted by SUJU
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.
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.Quote:
VBA is the macro programming language used by Office since Office 97.
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.Quote:
Originally Posted by XL-Dennis