Excel VBA or Excel Macros? - Is there a difference?

I hear people talking about Excel macros and Excel VBA.  Are the terms interchangeable?   Excel Macros are written in Excel VBA.   So are all procedures macros?
brothertruffle880Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

ProfessorJimJamMicrosoft Excel ExpertCommented:
They're basically the same thing: VBA is the language you use to program macros and functions. The difference would be VBA code can contain both functions and macros where as a macro code is only the macro part of the code.
A 'macro' is usually vb written for use in Excel  and sometimes will have been created using a macro recorder, where your actions are interpreted and turned into code.

Recorded Macros - When a macro is recorded you will often create a substantial amount of code that is completely unnecessary (ie. scroll downs).  This is often the most simplest method to create automation.  
VBA scripts - Using effective VBA scripts allows you to eliminate unnecessary steps which improves your speed.  This becomes a very important factor as you add more steps, apply to growing data sets, or when multiple functions are involved.  Remember, your computer has to walk through each step in your script so keeping it short is key

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Rory ArchibaldCommented:
Typically, people are referring to the same thing, but there is still the old XLM macro language which is different from VBA.
brothertruffle880Author Commented:
Great explanation.  Thanks!
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.