Difference between VB and VBA?

[Mike]

Hi everyone,

What exactly the difference between VB and VBA?

Thanks,
Mike

 

[John Coleman]

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]

Now, say you have created a macro in Excel. Can you take its VBA code
and convert it into a VB one?

If yes, can you give an example please?

Thaks,
Mike