Читать книгу Excel VBA Programming For Dummies - Dick Kusleika - Страница 23
Knowing what VBA does best
ОглавлениеHere are some benefits of automating a task by using VBA:
Excel always executes the task in exactly the same way. (In most cases, consistency is a good thing.)
Excel performs the task much faster than you can do it manually. (Unless, of course, you’re Clark Kent.)
If you’re a good macro programmer, Excel always performs the task without errors (which probably can’t be said about you, no matter how careful you are).
If you set up things properly, someone who doesn’t know anything about Excel can perform the task by running the macro.
You can do things in Excel that are otherwise impossible — which can make you a very popular person around the office.
For long, time-consuming tasks, you don’t have to sit in front of your computer and get bored. Excel does the work while you hang out at the water cooler.