Difference Between Modules and Macros

C

Chris

I am curious on the difference between Modules and
Macros. Can some one give me a brief description on each
and tell me when I should write one.
 
M

Marshall Barton

Chris said:
I am curious on the difference between Modules and
Macros. Can some one give me a brief description on each
and tell me when I should write one.


A good Access book provides a lot better explaination of
this kind of stuff than you can get from newsgroup posts.

A module is a container for VBA code procedures, which are
far, far and away more powerful than macros. In general you
should never use a macro if there's a way to do the job in
VBA. There are only a couple of exceptions, AutoKeys and
AutoExec.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top