Limits of macros

This article explores what you can and cannot do with Macros.

For simple automation of tasks, any tasks, Macros are an extremely powerful tool. The Macro functionality in Microsoft Office is extremely mature and sophisticated. So chances are that what we have seen so far should be enough in 90% of the cases.

However, if you want to do any of the following things,

  • Check for conditionality
  • Loop an action(Repeat the same action many times automatically without user intervention)
  • Create custom forms

you will find the simple Macro creator insufficient for your needs. In such cases, you will have to resort to the extremely powerful and sophisticated VBA editor for your needs.

This entry was posted on October 1, 2006 at 9:23 pm and is filed under Macros, Microsoft Excel, Microsoft Office. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Leave a Reply