The core language (syntax, control flow, etc) are exactly the same (if
you are comparing VB6 with VBA - all bets are off if you are talking
about
VB.Net). The main difference is that
VB can make stand-alone
executables whereas VBA must be hosted in an application like Excel to
run. Another difference is that
VB is fully compiled but VBA is only
partially compiled (into "p-code") which is then run on an interpreter.
Thus a
VB program will be quicker than the corresponding VBA program
(but not by as much as you might think - the partial compilation of VBA
makes it much closer to
VB than to the purely interpreted VBScript).
HTH
-John Coleman
Mike wrote:
Hi everyone,
What exactly the difference between VB and VBA?
Thanks,
Mike