View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
John Coleman John Coleman is offline
external usenet poster
 
Posts: 274
Default Difference between VB and VBA?

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