Automation and repetition
VBA is effective and efficient when it comes to repetitive solutions to … 展开

Using code to make applications do things
You might think that writing code is mysterious or difficult, but the basic principles use every-day reasoning and are quite accessible… 展开

Now that you know something about how Office applications expose their object models, you are probably eager to try calling object methods, setting object properties, and r… 展开

Start with examples
The VBA community is very large; a search on the Web can almost always yield an example of VBA code that does something similar to what y… 展开

Variables
In the simple examples in this article you manipulated objects that the application had already created. You might want to create your own … 展开