What is difference between VBScript and VBA?

for Technical interviews:

http://no1tutorial.com/

learn step by step technologies:


http://no1tutorial.com/
What is difference between VBScript and VBA?


VBScript is a subset of Visual Basic for Applications, but there are still many differences:


VBScript doesn't have a debugger like Visual Basic or you can say that VBScript does not provide any debugging features. you'll resort to using lots of message boxes, instead.


Unlike Visual Basic and Visual Basic for Applications, in which the developer can define the data type of a variable in advance, all variables in VBScript are variants.


There is no intergrated development environment for VBScript that parallels the IDE for Visual Basic and Visual Basic for Applications.


Because variables are untyped and code is not complied, all external objects instantiated in VBScript code are neccessarily late-bound. This has a number of implications. First, late binding typically entails a substantial performance penalty in comparison to early binding. Second, while the properties and methods of early-bound objects can ve examined in Visual Basic or hosted VBA environments using the Object Browser, this is not the case with late-bound objects. Finally, the help facilities available for early-bound objects in VB and VBA (like Auto List Members and Auto Quick Info) are not available, making syntax errors more likely and ready access to good documentation all the more neccessary.