HOW TO : EXCEL/WORD @ VSTO 2005

Basic Workbook Tasks

How to: Create New Workbooks

How to: Open Workbooks

How to: Open Text Files as Workbooks

How to: Activate Workbooks

How to: Save Workbooks

How to: Send Workbooks by E-Mail Programmatically

How to: Close Workbooks

How to: Display a Dialog Box to Open Excel Files

How to: Get and Set the Default File Path for Workbooks

How to: List Recently Used Workbook Files

Basic Worksheet Tasks

How to: Display a String in a Worksheet Cell

How to: Select Worksheets

How to: Add New Worksheets to Workbooks

How to: Delete Worksheets from Workbooks

How to: Hide Worksheets

How to: Move Worksheets Within Workbooks

How to: List All Worksheets in a Workbook

How to: Print Worksheets

How to: Sort Data in Worksheets Programmatically

How to: Add and Delete Worksheet Comments

How to: Display Worksheet Comments

How to: Create Groups in Worksheets

How to: Clear Groups in Worksheets

How to: Refer to Worksheet Ranges in Code

How to: Send Values to Worksheet Cells

How to: Display the Current User's Logon ID in a Cell

How to: Store and Retrieve Date Values in Excel Ranges

Securing Workbooks

How to: Protect Workbooks

How to: Protect Worksheets

How to: Remove Protection from Worksheets

How to: Set and Clear Workbook Passwords

Formatting

How to: Apply Styles to Ranges in Workbooks

How to: Clear Styles from Ranges in Workbooks

How to: Copy Data and Formatting across Worksheets

How to: Change Formatting in Worksheet Rows Containing Selected Cells

Working with Ranges

How to: Run Excel Calculations Programmatically

How to: Check Spelling in Worksheets

How to: Automatically Fill Ranges with Incrementally Changing Data

How to: Search for Text in Worksheet Ranges

Basic Document Tasks

How to: Create New Documents

How to: Open Existing Documents

How to: Save Documents

How to: Close Documents

How to: Reference Documents in the Documents Collection

How to: Use Built-In Dialog Boxes in Word

How to: Use Word Dialog Boxes in Hidden Mode

How to: Add Pictures and Word Art to Documents

How to: Display Documents in Print Preview

How to: Print Documents

How to: Protect Documents and Parts of Documents

How to: Check Spelling in Documents

How to: Add Headers and Footers to Documents

Text and Objects in Documents

How to: Insert Text into Word Documents

How to: Count Characters in Documents

How to: Format Text in Documents

How to: Hide Text in Documents

How to: Exclude Paragraph Marks When Creating Ranges

How to: Update Bookmark Text

How to: Define and Select Ranges in Documents

How to: Extend Ranges in Documents

How to: Retrieve Start and End Characters in Ranges

How to: Add Comments to Text in Documents

How to: Remove All Comments from Documents

How to: Reset Ranges in Word Documents

How to: Collapse Ranges or Selections in Documents

Searching and Replacing Text in Documents

How to: Search for Text in Documents

How to: Set Search Options in Word

How to: Loop Through Found Items in Documents

How to: Search for and Replace Text in Documents

How to: Restore Selections After Searches

Word Tables in Documents

How to: Create Word Tables

How to: Add Text and Formatting to Cells in Word Tables

How to: Add Rows and Columns to Word Tables

How to: Populate Word Tables with Document Properties

How to: Resize Columns in Tables

Suresh Behera