What are the differences between Visual Basic, VB for Applications and VBS? A quick Google search brought me the terse gem that “VBA is Visual Basic within other applications such as Excel and Access”, but that didn’t really seem satisfying. Are they substantially similar?
I can write code in Access and Excel – but then I wonder whether if it is really VB, or VBA. Would I notice the difference in syntax, terms and so on in each?
Arse. I didn’t cut the Java bit out of the thread title.
Don’t worry about that part. I have read about the differences between Java and Javascript, and was only looking for a nice summary, but I should be able to do that search for myself.
VBA is substantially similar to VB, but (for example) VBA in Access is tweaked to emphasise the controls and functions that you’d typically need in a database application; it is a fair bit easier to get at the data from VBA in Access because the system can largely assume that you are talking about the loaded database, whereas in VB proper, you have to add controls to link to it. In VBA you get extra application-specific functions and methods that simply are not available in VB - In some ways this makes VBA more powerful than VB.
The main drawbakc is probably that you can’t compile a true standalone executable application in VBA
vba and vbs are basically a subset of vb - the language looks and feels the same but there is quite a lot of functionality stripped out - for example classes & arrays work differently in vbs & vba to vb proper.