Secrets of the Office Masters: Elements of Programming Style for the Nonprogrammer
by Woody Leonhard, Ed Bott
Special Edition Using Microsoft® Office XP
- Copyright
- About the Authors
- Acknowledgments
- Tell Us What You Think!
- Introduction
- Common Tasks and Features
- An Overview of Office XP
- Customizing the Office Interface
- Controlling Automatic Interface Changes
- Customizing Toolbars
- Creating a New Toolbar
- Customizing Built-In Menus
- Bypassing Menus with Keyboard Shortcuts
- Configuring Common Office Features
- Setting Security Options
- Saving and Restoring Personal Settings
- Troubleshooting
- Secrets of the Office Masters: Custom Toolbars for Quick Highlighting
- Office File Management for Experts
- Editing and Formatting Text
- Entering Text
- Selecting Text
- Finding and Replacing Text
- Converting Scanned Documents to Text
- Using Speech Recognition to Enter Text
- Using AutoCorrect to Automate Documents
- Using and Managing Fonts
- Common Formatting Options
- Undoing and Redoing Changes
- Troubleshooting
- Secrets of the Office Masters: Using AutoCorrect to Add a Digital Signature to Your Documents
- Creating and Editing Professional-Quality Graphics
- Sharing Data Between Office Applications
- Using Office on the Web
- Sharing Office Documents
- Using Outlook
- Outlook Essentials
- Is Outlook the Heart of Office?
- Setting Up E-mail Accounts and Connections
- Managing Outlook Data Files
- Using and Customizing the Outlook Interface
- Creating, Editing, and Managing Outlook Items
- Creating Reminders and Flagging Items for Follow-Up
- Using Custom Views to Display Information
- Finding Outlook Items
- Integrating Outlook with Exchange Server
- Importing and Exporting Outlook Information
- Troubleshooting
- Secrets of the Office Masters: Building a Library of Saved Searches
- Expert E-mail Management
- Managing Multiple E-mail Accounts
- Creating, Managing, and Using E-mail Addresses
- Using Word as an E-mail Editor
- Creating and Sending Messages
- Checking Your Mail and Reading New Messages
- Working with Attachments
- Organizing Your E-mail
- Troubleshooting
- Secrets of the Office Masters: Expert Strategies for Outlook Rules
- Tracking Appointments and Tasks
- Managing a Contacts List
- Managing Your List of Contacts
- Entering and Editing Contact Information
- Working Smarter with Contact Items
- Using MSN Messenger to Communicate with Contacts
- Addressing Letters and Envelopes Using Your Contacts List
- Printing Phone Lists from Your Contacts List
- Troubleshooting
- Secrets of the Office Masters: Mapping a Contact's Address
- Sharing Schedules and Planning Meetings
- Outlook Essentials
- Using Word
- Word Essentials
- Avoiding Compatibility Problems
- Batch Conversions with the Conversion Wizard
- Understanding Your Formatting Options
- Applying and Modifying Formats
- Choosing the Right Document View
- Printing Word Documents
- Customizing the Word Interface
- Word Startup Switches
- Troubleshooting
- Secrets of the Office Masters: Styles and Manually Applied Formatting
- Expert Text-Editing Techniques
- Navigating Through a Word Document
- Finding and Replacing Text and Other Parts of a Document
- Entering Text and Graphics Automatically with AutoText and AutoCorrect
- Using Hyphens and Dashes
- Changing Text Formatting
- Changing Paragraph Formatting
- Using the Ruler to Set Tab Stops and Indents
- Formatting Simple Lists with Bullets and Numbers
- Formatting All or Part of a Document Automatically
- Checking Spelling and Grammar
- Sharing Documents
- Troubleshooting
- Secrets of the Office Masters: Combining Revision Marks and Comments
- Advanced Document Formatting
- Adjusting Margins
- Changing Paper Size and Orientation
- Inserting and Deleting Manual Page Breaks
- Formatting Documents by Section
- Adding Lines, Borders, Shading, and Backgrounds
- Formatting a Document with Columns
- Faking Columns with Linked Text Boxes
- Creating and Editing Headers and Footers
- Creating and Editing Letters
- Creating Envelopes and Labels
- Keeping Long Documents Under Control
- Wrapping Text Around Graphics
- Summarizing a Document Automatically
- Troubleshooting
- Secrets of the Office Masters: Creative Newsletter Layouts
- Using Tables
- Using Styles, Templates, and Themes
- Using Styles and Templates to Manage Formats
- Formatting Documents with Styles
- Saving Formats as Named Styles
- Customizing the Normal Document Template
- Using Word's Built-In Templates
- Changing Document Formats Globally
- Managing Styles and Templates
- Troubleshooting
- Secrets of the Office Masters: Using a Macro to Replace Straight Quotes with Curly Quotes
- Creating Dynamic Documents with Fields and Forms
- Merging Data and Documents
- Word Essentials
- Using Excel
- Excel Essentials
- Working with Worksheets and Workbooks
- File Compatibility Issues
- Using Ranges to Work with Multiple Cells
- Hiding Rows and Columns
- Finding, Replacing, and Transforming Data
- Customizing the Worksheet Window
- Using Links to Automatically Update or Consolidate Worksheet Data
- Restricting and Validating Data Entry for a Cell or Range
- Printing Worksheets
- Publishing Excel Data in Web Pages
- Customizing Excel
- Troubleshooting
- Secrets of the Office Masters: Beware of Undo
- Advanced Worksheet Formatting
- How Cell Formatting Works
- Changing Formatting for a Cell or Range
- Designing and Formatting a Worksheet for Maximum Readability
- Using Conditional Formatting to Identify Key Values
- Copying Formats with the Format Painter
- Saving Formats as Named Styles
- Using AutoFormat
- Troubleshooting
- Secrets of the Office Masters: Redesigning a Worksheet Clarifies the Information
- Using Formulas and Functions
- Creating and Editing Charts
- Working with Lists and Databases
- Creating a List on a Worksheet
- Speeding Up Repetitive Data Entry with AutoComplete
- Automatically Filling In a Series of Data
- Sorting Lists
- Finding and Filtering Data in a List
- Using Forms to Add and Edit List Data
- Importing and Exporting Data
- Creating Links to External Databases
- Creating and Using Web Queries
- Troubleshooting
- Secrets of the Office Masters: Combine Data from Several Web Sources in a Custom Page
- Using Excel in a Workgroup
- Using PivotTables and PivotCharts
- Excel Essentials
- Using PowerPoint
- Other Office Applications
- Automating Office with Macros and VBA
- Appendixes
- Index
Secrets of the Office Masters: Elements of Programming Style for the Nonprogrammer
Even if you're new to programming and have only just begun writing your first VBA programs, you should always keep several tips in mind:
Use lots of comments. Yes, you can remember precisely what each line of code in your program does, and what each variable's duty in life might be. But when you look at your program a year from now, it will all be gibberish unless you add a lot of comments now, while it's still fresh in your mind.
Don't be afraid to experiment. You aren't going to break anything. The real beauty of VBA is that you can try something, see how (or whether) it works, and then try something else. Amazing things have been discovered by trial and error.
Remember that nothing is perfect, and VBA certainly follows that rule. Although VBA itself is reasonably stable and predictable, the underlying object models in all the Office applications have lots and lots (and lots and lots) of rough edges. Go slowly, step through all your programs, and be observant.
Test. Then test some more. Then give your program to 10 friends, and have them all test it even more. Everyone has a slightly different configuration, and odd settings can throw off even the most well-conceived program.
Keep your sense of humor. Programming is fun. But it's also hard work. The machine isn't out to get you—even though there will certainly be days when you think it is.
Ask questions. Nobody knows it all. And even if they did, by the time they figured out the last nuance of the last feature, they would've forgotten what they knew in the first place.
No matter what happens, there's always another revision. VBA is a dynamic language and every new version brings some exciting new capabilities. Stay on top of the wave, and you'll be able to solve problems that would curl the hair of mere mortals.
-
No Comment