Is there any difference between a VBA Program and Macro?

[lezawang]

Hi
That question is answered in the article below. The author is saying macro and vba are different. I am very confused now. I thought macros (recording macro) are vba sub routines, am I right? I thought these recorded macros will be saved as vba subs

https://www.exceltrick.com/excel-vba-basics/what-is-excel-vba/

 

[Ron Coderre]

Hover the mouse pointer over the icon next to "Ready" on the task bar.
What text is displayed?
"No macros are currently recording. Click to begin recording a new macro."
Those recorded macros will be written in VBA.
Any questions?

 

[Michael M]

A macro is a set of instructions using VBA.....
So a macro might consist of 1 line of VBA or thousands of lines !!

 

[Fazza]

The author explains, in the article,

"[FONT=&quot]Macros were used with the older versions of office applications and they could only be used for automating instructions."
and
"... [/FONT][FONT=&quot]VBA later in 1993 replaced this Macro Language, and hence there is still a misconception among people to call VBA as macro language."

So the author's view is that only the early programming approach should be called macros. And this was superseded by VBA many years ago. OK?[/FONT]

 

[MARK858]

As Michael has stated a macro is a generic term for a set of instructions, VBA is a programming language (as Ron has inferred).