Macro vs VBA

D

David M C

Could someone please explain when you would use a macro and when you would
use VBA? So far, I've accomplished everything I need to using VBA and can't
see why you would use macro's at all.

Thanks,

Dave
 
D

Douglas J. Steele

Not quite. There's no easy way to do the equivalent of the AutoKeys macro
using VBA.
 
G

George Nicholson

The only macro in any of my apps is AutoExec, which simply calls a VBA
procedure which opens the startup form while doing other housekeeping
chores, etc.
Even that little bit could be easily worked around as long as you were 100%
sure you would never, ever, ever forget to set your Startup form (six, meet
half-dozen). A matter of personal preference (no code behind my startup
form)

Biggest drawback to macros: no error handling.
2nd biggest: VBA more robust

HTH,
 
Top