| |
| |
| Foreword | |
| |
| |
| About the Authors and Contributors | |
| |
| |
| Juan Pablo Gonzalez | |
| |
| |
| Cindy Meister | |
| |
| |
| Suat Ozgur | |
| |
| |
| Bill Dilworth | |
| |
| |
| Nico Altink | |
| |
| |
| Contributors | |
| |
| |
| Introduction | |
| |
| |
| What is VBA? | |
| |
| |
| Save Time | |
| |
| |
| Take Advantage of UserForms | |
| |
| |
| Develop User-defined Functions | |
| |
| |
| Enjoy Security | |
| |
| |
| How to Use This Book | |
| |
| |
| Using the Procedures | |
| |
| |
| Understanding Code Comments | |
| |
| |
| Inserting Paragraph Returns in Code | |
| |
| |
| Using Menu Commands | |
| |
| |
| Identifying Procedure Components | |
| |
| |
| Using Sample Files | |
| |
| |
| Backup Your Files! | |
| |
| |
| Version Compatibility | |
| |
| |
| Introducing the Visual Basic Editor | |
| |
| |
| Accessing Visual Basic Editor (VBE) | |
| |
| |
| Touring the VBE Toolbar | |
| |
| |
| Setting VBE Options | |
| |
| |
| Using Project Explorer | |
| |
| |
| Understanding VBA Project | |
| |
| |
| Working with Modules | |
| |
| |
| Using the Main Code Window | |
| |
| |
| Protecting Your Projects | |
| |
| |
| Excel Procedures | |
| |
| |
| Printing All Files | |
| |
| |
| Saving a Workbook as Today's Date | |
| |
| |
| Highlighting Duplicates Within a Range | |
| |
| |
| Sorting Worksheets | |
| |
| |
| Generating a Unique List | |
| |
| |
| Using AutoFilter on a Protected Sheet | |
| |
| |
| Deleting Rows Based on Criteria | |
| |
| |
| Checking Whether or Not a File Exists | |
| |
| |
| Removing Hyperlinks | |
| |
| |
| Applying SUM / COUNT by Color | |
| |
| |
| Using More Than Three Conditional Formats | |
| |
| |
| Providing a Calendar to Choose Dates for Input | |
| |
| |
| Restricting Text Box Entry to Numbers | |
| |
| |
| Running a Macro When a Cell Changes | |
| |
| |
| Forcing the Use of a Custom Print Procedure | |
| |
| |
| Restricting the User to a Portion of the Worksheet | |
| |
| |
| Copying a Workbook with Macros Removed | |
| |
| |
| Inserting Empty Rows in a Range | |
| |
| |
| Creating a Custom Toolbar | |
| |
| |
| Creating a Table of Contents of a Workbook | |
| |
| |
| Changing the Case of Text | |
| |
| |
| Creating a Photo Album | |
| |
| |
| Deleting the Empty Rows in a Range | |
| |
| |
| Creating a List of Files That Reside in a Directory | |
| |
| |
| Forcing the User to Enable Macros | |
| |
| |
| Finding and Replacing a String in All Open Workbooks | |
| |
| |
| Converting Data to a Tabular Format | |
| |
| |
| AutoNumbering Invoices and Other Workbooks | |
| |
| |
| Comparing Columns Using Various Criteria | |
| |
| |
| Deleting the Contents of Unlocked Cells | |
| |
| |
| Hiding All Standard Toolbars Except Your Own | |
| |
| |
| Creating a PPT Presentation from a Pivot Chart | |
| |
| |
| Saving a Backup Copy of a Workbook | |
| |
| |
| Importing Your Contacts from Outlook | |
| |
| |
| E-mailing from Excel with Outlook | |
| |
| |
| Printing a UserForm | |
| |
| |
| Importing and Formatting a Text File | |
| |
| |
| Extracting Numbers from a Text String | |
| |
| |
| Finding and Deleting Erroneously Named Ranges | |
| |
| |
| Logging Actions When a Cell Changes | |
| |
| |
| Synchronizing Page Fields of Pivot Tables | |
| |
| |
| Word Procedures | |
| |
| |
| Applying Your Favorite Bullet/Number Format | |
| |
| |
| Finding and Replacing in Multiple Documents | |
| |
| |
| Highlighting a Selection | |
| |
| |
| Highlighting a Selection in Word 2002/XP | |
| |
| |
| Removing All Highlighting | |
| |
| |
| Inserting AutoText with No Formatting | |
| |
| |
| Updating All Fields | |
| |
| |
| Setting Hyperlinks on Index Entries | |
| |
| |
| Displaying a Number in Millions as Text | |
| |
| |
| Copying Nested Field Codes as Text | |
| |
| |
| Converting AutoNumbered Text into Normal Text | |
| |
| |
| Reverse Numbering | |
| |
| |
| Tables: Changing the Tab Direction | |
| |
| |
| Tables: Suppressing New Rows When Tabbing | |
| |
| |
| Tables: Formatting Numbers in a Selection | |
| |
| |
| Tables: Copying Formulas | |
| |
| |
| Using Calendar Wizard | |
| |
| |
| Formatting Your Calendar | |
| |
| |
| Inserting a Picture with Caption | |
| |
| |
| Making Changes | |
| |
| |
| Associating a Picture with a Page | |
| |
| |
| Forms: Suppressing New Paragraphs in Form Fields | |
| |
| |
| Forms: Formatting Text Input in Form Fields | |
| |
| |
| Changing Other Types of Formatting | |
| |
| |
| Forms: Inserting a New Table Row | |
| |
| |
| Forms: Deleting a Table Row | |
| |
| |
| Forms: Placing a Picture in a Protected Form | |
| |
| |
| Mail Merge: Using a Relative Path for Data Source | |
| |
| |
| Mail Merge: Displaying the Mail Merge Interface | |
| |
| |
| Mail Merge: Creating a User-Friendly List of Fields | |
| |
| |
| Mail Merge: Making Placecards Using WordArt | |
| |
| |
| Mail Merge: Creating a One-to-Many List | |
| |
| |
| Mail Merge: Merging with a Chart | |
| |
| |
| Transferring a Selection to a New Document | |
| |
| |
| Splitting a Document into Multiple Files | |
| |
| |
| Creating a Folder Tree Menu | |
| |
| |
| Changing Custom Dictionaries On-the-Fly | |
| |
| |
| Formatting Spelling Errors for Printing | |
| |
| |
| Entering Data Easily Using a Custom Dialog Box | |
| |
| |
| Creating a Bookmark from a Selection | |
| |
| |
| Making Bookmarks Visible | |
| |
| |
| Forcing the User to Enable Macros | |
| |
| |
| Generating the Document Using VBA | |
| |
| |
| Using Forms Protection | |
| |
| |
| Macros in Files Opened by Code | |
| |
| |
| Outlook Procedures | |
| |
| |
| Creating Control Buttons | |
| |
| |
| Saving E-mail Attachments in a Specified Folder | |
| |
| |
| Creating a Contacts Database | |
| |
| |
| Sending a Web Page as the Body of an E-mail Message | |
| |
| |
| Sending a Message Individually to Multiple Recipients | |
| |
| |
| Sending Daily Attachments to Certain Recipients | |
| |
| |
| Creating Reminders Automatically | |
| |
| |
| Creating Task Items Automatically in Outlook | |
| |
| |
| Special: Outlook Security | |
| |
| |
| Auto Replying to Selected E-mail Messages | |
| |
| |
| Remote Control with Outlook E-mail Message | |
| |
| |
| PowerPoint Procedures | |
| |
| |
| Inserting a Predefined Number of Slides | |
| |
| |
| Manipulating AutoShapes | |
| |
| |
| Grabbing All Text | |
| |
| |
| Moving Shapes and Graphics During Presentation | |
| |
| |
| Making a Random Jump to Another Slide | |
| |
| |
| Random Madness | |
| |
| |
| Sending Word Outline to Notes Section of PowerPoint | |
| |
| |
| Wrapping Text to the Next Slide | |
| |
| |
| Saving the Show Point | |
| |
| |
| Personalizing a Presentation | |
| |
| |
| Creating a New Presentation | |
| |
| |
| Access Procedures | |
| |
| |
| Splitting Names | |
| |
| |
| Designing Consistent Forms | |
| |
| |
| Triggering a New Form Based on a Subform Selection | |
| |
| |
| Selecting and Filtering with Cascading Combo Boxes | |
| |
| |
| E-mailing a Selection | |
| |
| |
| Making a Rolodex-type Selection Listbox | |
| |
| |
| Validating Data | |
| |
| |
| Moving Rows Between Listboxes | |
| |
| |
| Moving Rows in Listboxes | |
| |
| |
| Creating a Dynamic Crosstab Report | |
| |
| |
| Generating Periodic Reports | |
| |
| |
| Creating Controlled Numbers | |
| |
| |
| Making a Wizard with Tabbed Control | |
| |
| |
| Combined Procedures | |
| |
| |
| Transferring Charts From Excel to PowerPoint | |
| |
| |
| Saving Word Form Data to an Excel Spreadsheet | |
| |
| |
| Filling a Word Combo Box with Data from Excel | |
| |
| |
| Transferring Data from E-mail Attachments to Excel | |
| |
| |
| Creating Word Labels from an Excel Recipient List | |
| |
| |
| Creating Custom Mail Merge Using Data in Excel Worksheet | |
| |
| |
| Using Calendar Control for Office Applications | |
| |
| |
| |
| |
| |
| Opening and Using the Visual Basic Editor | |
| |
| |
| Locating the Code Object | |
| |
| |
| Inserting a Module | |
| |
| |
| Inserting a UserForm | |
| |
| |
| Opening Worksheet Objects (Excel) | |
| |
| |
| Opening ThisWorkbook Object (Excel) | |
| |
| |
| Opening ThisDocument Objects (Word) | |
| |
| |
| Opening ThisOutlookSession Objects (Outlook) | |
| |
| |
| Opening Slide Objects (Powerpoint) | |
| |
| |
| Access Objects | |
| |
| |
| |
| |
| |
| Running a macro | |
| |
| |
| Running a Macro Automatically | |
| |
| |
| Running a Macro Manually | |
| |
| |
| Running a Macro from a Toolbar Button | |
| |
| |
| Running a Macro Using Shortcut Keys | |
| |
| |
| Index | |