TechNet Home > Script Center > Learn to Script > Office Space: Tips and Tricks for Scripting Microsoft Office Applications

The Office Space Archive

*

Previous articles posted in Office Space, the twice-weekly column that provides answers to your Microsoft Office scripting questions. If you have a question you’d like to see addressed in Office Space, email us at scripter@microsoft.com.

•Microsoft Office (General)

Animating the Microsoft Office Assistant (Part 1)
Animating the Microsoft Office Assistant (Part 2)

•Microsoft Access

Reading Data from a Microsoft Access Database
Importing and Exporting XML Data Using Microsoft Access

•Microsoft Excel

Sorting Data in Microsoft Excel
Putting Borders Around Spreadsheet Cells
Searching for Files Using Microsoft Excel: Part 2
Searching for Files Using Microsoft Excel
Using ADO to Query an Excel Spreadsheet
Adding Comments to an Excel Spreadsheet
Using the Text to Columns Feature in Microsoft Excel
Appending Data to an Excel Spreadsheet
Creating a Calendar Using Excel’s AutoFill Feature
Changing the Background Color of a Cell
Wrapping Text in an Excel Spreadsheet
Inserting a Formula into an Excel Spreadsheet
Renaming an Excel Worksheet
Working with Other Worksheets in a Workbook

•Microsoft Outlook

Tallying Mail Messages Using Microsoft Outlook
Adding a List of Holidays to Microsoft Outlook
Working with Outlook Tasks
Retrieving a List of Recurring Appointments from Microsoft Outlook
Filtering Email Messages in Microsoft Outlook
Saving All the Attachments in Your Inbox
Starting a Script Regardless of Whether or Not Microsoft Outlook is Already Running
Retrieving the Members of Outlook Distribution Lists
Exporting Contact Information to Microsoft Excel
Creating a Microsoft Outlook Contact
Creating a Microsoft Outlook Appointment
Finding the Number of Unread Messages in Your Inbox

•Microsoft Excel Graphs and Charts

Creating Line Charts in Microsoft Excel
Creating Pie Charts in Microsoft Excel
Saving Charts and Graphs
Adding Color and Panache to Your Column Charts
Formatting the Basic Column Chart
The Basic Column Chart

•Microsoft Word

Printing Documents Using Microsoft Word
Adding Pictures to a Microsoft Word Document
Calling a File Open Dialog Box from Microsoft Word
Adding Line Numbers to a Microsoft Word Document
Adding WordArt to a Microsoft Word Document
Using the Spelling Checker in Microsoft Word
Inserting Formulas in a Microsoft Word Table
Creating Tables in Microsoft Word
Creating Multi-Column Documents in Microsoft Word
Applying a Theme to a Microsoft Word Document
Putting a Border Around a Paragraph in Microsoft Word
Adding Picture Bullets to a Microsoft Word Document
Retrieving a List of Microsoft Word Keyboard Shortcuts
Retrieving Hyperlinks from a Word Document
Appending Text to a Microsoft Word Document
Finding and Replacing Text in a Microsoft Word Document
Retrieving a Formatted List of Available Fonts
Inserting a Date-Time Field into a Microsoft Word Document
Creating a Bulleted List in Microsoft Word
Manipulating Word’s Recent Files List
Adding a Drop Cap to a Paragraph
Changing the Background Color of a Paragraph
Inserting AutoText Using a Script
Getting Statistics for a Word Document
Inserting a Page Break in a Word Document
Adding Page Numbers to a Microsoft Word Document

Top of pageTop of page