C# / vb.net & vba?

tinfanide · #1 02-01-2012, 07:17 AM

I started learning coding in the Office environment with VBA. I know it stands for Visual Basic for Application. As long as getting along with Windows, I started learning some VB.NET but always wonder why in every MSDN VBA reference page, there must be VB, C#, F#... code demostration.

Is VBA VB? I found they have some style differences:

Code:

' VBA
Dim var As Object
Set var = obj

'VB.NET
Dim var As Object = obj
' No "set" (to the best of my knowledge) in VB

And can I use C# in VBE, the VBA editor?

Or can I control Office Applications in C# in Visual Studio or just simply on Notepad and compile the codes in DOS?