Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Is Excel VBA the same as VB.NET

Tags:

vb.net

vba

Is VB.NET the same language that is used in Excel 2003/2007 in the user editable code you can write in the backgrouund?

like image 939
Coops Avatar asked Jul 16 '12 10:07

Coops


2 Answers

No, Excel 2003 and 2007 use Visual Basic for Applications, which is a variation of Visual Basic 6. This is an enormous change from VB.NET. See here for more details about specific differences.

like image 148
tenfour Avatar answered Oct 04 '22 08:10

tenfour


No, the only similarity between VBA and VB.NET is the similar-looking syntax.

VBA is similar to Visual Basic 6, which is obsolete since about 1997 (?), so VBA is not a very modern language.

VB.NET is a modern language, having the same capabilities as C#, but the syntax is terrible, so I personally prefer C#.

VBA is an interpreted language, while VB.NET is compiled.

If you are interested in Office programming, you might consider doing your next Office project in VB.NET and VSTO, which is the modern alternative to VBA.

like image 34
JohnB Avatar answered Oct 04 '22 08:10

JohnB