VB.net "vs" Excel VBA

[Nikolis]

Hello everybody,

I have recently started learning Excel VBA, with an eye of making a couple of apps for myself. However, I would now be interested to make them as .exe files and standalone projects, so that I might possibly be able to sell them. So far I realize that ;
- Excel VBA needs ... Excel but leads to no .exe ,
- the original Visual Basic has not been standalone for years and was more like a DOS-based language (only code, no visual components etc.),
- VB.net (while not considered as high as Python, Java etc.) is standalone and does lead to .exe, also does have the visual components that I use in Excel VBA userforms.

Long story short ; with the exception of cells/ranges (maybe with arrays replacing them) does VB.net have 100% the same code/syntax as Excel VBA, so that I wouldn't have to learn a new language from the beginning ? Meaning, is it the modern version of the "old" VB but without the Excel part ?

Thank you in advance.

 

[Joe4]

Long story short ; with the exception of cells/ranges (maybe with arrays replacing them) does VB.net have 100% the same code/syntax as Excel VBA, so that I wouldn't have to learn a new language from the beginning

No, it does not.
There are a number of similiarities, but they are NOT the same.
Knowing one may help you in learning the other (due to the similiarities), so you kind of have a heard start.

 

[Nikolis]

Joe4 thank you for your attention and input !

 

[Joe4]

You are welcome.

 

[kanchu10]

Hey,
VBA is an interpreted language, while VB.NET is compiled. in VB.NET data is handled using the ADO.net protocol, while in VBA data connectivity and handling are done through DAO, RDO and ADO protocol.
VB.NET is a modern, fully object-oriented language that replaced VB6, while VB is the predecessor of VB.NET and was not an object-oriented language.
A multiplethreaded application can be developed in VB.NET.

 

[Nikolis]

Thank you *kanchu10 !