Common Tasks in Office Programming
Projects
How do I...
- Create Word and Excel projects?
- Install Office primary interop assemblies (PIAs)?
- Add a reference to an Office primary interop assembly?
- Add template behavior to a Microsoft Excel 2003 workbook?
- Open a Windows Form from an Office document?
- Set custom properties in a document?
Excel Automation
How do I...
- Create new workbooks?
- Open workbooks?
- Save workbooks?
- Close workbooks?
- Add new worksheets to workbooks?
- Hide worksheets?
- Move worksheets within workbooks?
- Protect workbooks?
- Create new named ranges in worksheets?
- Refer to worksheet ranges in code?
- Change formatting in a row that contains a selected cell?
- Search for text in worksheet ranges?
- Send a value to a cell in a worksheet using Visual Basic .NET?
- Send a value to a cell in a worksheet using C#?
- Add a chart to a worksheet programmatically using Visual Basic .NET?
- Add a chart to a worksheet programmatically using C#?
- Display text in a text box using a button?
Word Automation
How do I...
- Create new documents?
- Open existing documents?
- Save documents?
- Close documents?
- Reference a document in the Documents collection?
- Insert text in a Word document?
- Define and Select Ranges in Documents?
- Format text in Word documents?
- Create bookmarks in Word documents?
- Update bookmark text?
- Search for text in Word documents?
- Send documents to a printer?
- Create Word tables?
Security
How do I...
- Grant permissions to folders and assemblies?
- Remove permissions from folders and assemblies?
- Bypass the assembly when I open an Office solution?
Deployment
How do I...
- Deploy Office solutions that use managed code extensions?
- Deploy for offline use of managed code extensions?
Suresh[Microsoft MVP.Net,India]