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