Advancing Your Office 2007 Power Using Visual Basic

Short Description
the Visual Basic for Application programming language several years ago to form … When you write a Visual Basic program to control an Office application, …

Website: www.informit.com | Filesize: 206kb

Content
Advancing Your Office 2007 Power: Using Visual Basic
By Greg Perry
Author of Sams Teach Yourself Office 2007 All-in-One (ISBN 0-672-32901-8)
You can automate many routine tasks that you perform with Office 2007’s products by recording your keystrokes and storing them in a macro. You can easily assign the macro to a keystroke such as Ctrl+Shift+F12 and Word or Excel will zip through your automated commands the moment you press the keys.
Recorded macro keystrokes have been around for years and many Office users are familiar with them. The only drawback is they are simple and don’t go the extra mile when you want something really automated.
For example, what if you consolidate a group of worksheets at the end of the month, performing some calculations, and printing them individually as well as a summary worksheet you create? You cannot automate such a major task no matter how routine it may be by recording your keystrokes.
You need more macro power. You need to use Visual Basic for Applications, or VBA.
In addition to the keyboard-recorded macros, many macros provide additional commands that go beyond the simple selection of menu…

Get the file Download here