What is a table?

What is a table?

What is a table?A table is an object that holds things. For example, a kitchen table hold things like plates, cups, and other things we use to eat our food. What is a database table?A database table also holds things. A database table holds data. How is the data...
Understanding the VBA Language

Understanding the VBA Language

After recording a macro in Microsoft Excel or Microsoft Word, often there is a need to edit the macro. However, before being able to successfully edit a macro written in VBA (Visual Basic for Applications), one first needs to know how to read it. That is the subject...
Sharing Macros

Sharing Macros

Our mothers taught us that you should share. Why? Because she said it would make us good play mates, would help our friends, and it would help keep peace in the home. Now that we are all grown up, we find the same is true in our organizations and with our macros. You...
Testing Macros

Testing Macros

The final step, before sharing a macro with others, is testing. Why? Well, would you buy a car without giving it a test drive? Of course not. Similarly, you need to know that your macro is going to work before you put it into production. This blog post covers how to...
How to record a macro

How to record a macro

This is the third article in a series about creating macros in Microsoft Excel and/or Microsoft Word. The first article, What is a macro? Defined what a macro is and how it can save you from having to do hours of tedious, repetitive work. The second article, Plan your...