Macro vs. VBA

[modest]

Please forgive me for my lack of knowledge, but what is the difference between a macro and using VBA?

Can't VBA do everything that a Macro can? What would be the additional benefit of using a macro over VBA and what can a macro do that VBA can't?

Thank you.

 

[Rich]

What would be the additional benefit of using a macro over VBA None
and what can a macro do that VBA can't?
Nothing




Thank you.

stupid reply limit

 

[wazz]

From the MSDN Website:

"Why Use Macros?
After reading all the reasons for using VBA, you may wonder if there are any reasons left for using macros. However, macros do have their place in many applications. Macros are an easy way to take care of simple details such as opening and closing forms, showing and hiding toolbars, and running reports. Because you specify options for each action in the lower part of the Macro window, there's little syntax to remember, and developing applications can often be faster than with VBA.

In addition to the ease of use macros provide, creating a macro is the only way to make global key assignments."

For more very useful info:
http://msdn.microsoft.com/library/d...0/html/acdecWhatsNewForDevelopersLanguage.asp

 

[modest]

From the MSDN Website:
"In addition to the ease of use macros provide, creating a macro is the only way to make global key assignments."

Am I then to assume that you could not make global key assignments in a module??



To me it seems like a macro is to VB, like what VB is to C++ or C#

 

[Mile-O]

Macros are just simple ways of stringing a sequence of methods together. These methods have underlying VBA methods (using DoCmd.method).

While new users seem to be either taught to use macros or simply gravitate towards them, there are different reasons not use them - I can't think of any reasons to actually make use of them.

The notable reasons are that they provide no error handling, they aren't flexible, and can take up valuable space.

 

[modest]

Good, cuz I don't want to use them. I was just wondering if I was missing anything. It seems like Macros = "beginner" and VB = "moderate - advanced"