book

Microsoft® .NET Development for Microsoft Office

by Andrew Whitechapel

December 2004

Intermediate to advanced

528 pages

14h 30m

English

Microsoft Press

Read now

Unlock full access

How This Book Is OrganizedWho This Book Is ForSystem Requirements and Code SamplesMicrosoft Learning Technical SupportAcknowledgments
1.1. Version Variations1.2. Notes on the Samples
2.1. Managed Interop AssembliesOffice XP PIAsOffice 2003 PIAs2.2. Basic Interop ProjectsBasic Interop with ExcelInterop with Office 97 and Office 2000Basic Interop with WordBasic Interop with OutlookBasic Interop with PowerPoint2.3. Visual Studio .NET Office Interop Wizards2.4. Interface/Class AmbiguityC# VersionVisual Basic .NET Version2.5. Releasing COM ObjectsSimple Garbage CollectionUsing ReleaseComObjectAppDomain Unloading2.6. Visual Basic .NET vs. C#Optional Parameters and Word Reference ParametersExcel Parameterized Properties and Word AccessorsAccessing Late-Bound Members2.7. Debugging Interop SolutionsUse Structured Exception HandlingCheck Assembly DependenciesSummary
3.1. Platform InvokeFunctions with Simple ParametersFunctions with Struct Parameters3.2. Watching Excel Quit3.3. Using COM by ReflectionUsing GetTypeFromProgIDTraversing a COM Object Model3.4. Document Properties3.5. Connecting to Running InstancesStarting Excel with Process.StartUsing GetActiveObjectUsing BindToMoniker3.6. Office Accessible Objects3.7. Monitoring Office ApplicationsPhase 1: Core FunctionalityPhase 2: Bringing Excel to the FrontPhase 2: Excel 2000 SpecificsSummary
4.1. Calling Managed Code from VBAManaged CodeClient VBA4.2. Managed CCW in VBAManaged ComponentManaged Test ClientVBA Client4.3. Managed Office AcceleratorsManaged CodeClient VBA4.4. Programming the Visual Basic Editor4.5. Office and Managed WindowsManaged Windows FormInterop InterfaceExcel VBA Client4.6. Office Document BrowserAdditional Step for Office 974.7. COM Drag-And-DropDropping Word TextDropping Excel TextDropping Excel CellsDropping into OfficeSummary
5.1. Managed COM Add-InsBasic Add-InAdd-In Connection/DisconnectionCustom ButtonWorking with the Setup Project5.2. Simple Add-In ProjectsExcel Add-InWord Add-InOutlook Add-InPowerPoint Add-In5.3. Multiple Host Applications5.4. Add-Ins and User ControlsCore Add-InCalendar and Clock Controls5.5. Tactical Add-In IssuesCommand UI Object ScopingButton ImagesAdd-In Disabling5.6. COM Add-Ins as Cell FunctionsManaged COM Add-InExcel Client5.7. Excel Automation Add-InsSummary
6.1. Managed Smart TagsThe Initial ProjectCustom Action BehaviorImplementing ISmartTagRecognizerImplementing ISmartTagActionBuilding and Deploying6.2. Smart Tags and the VSTO LoaderThe Initial ProjectImplementing ISmartTagRecognizer and ISmartTagActionBuilding and Deploying6.3. ISmartTagRecognizer2 and ISmartTagAction2Dynamic CaptionsCascading MenusThe Tokenizer6.4. MOSTL Smart Tags6.5. A MOSTL Generator6.6. Troubleshooting Smart TagsSummary
7.1. Excel and SQL Data7.2. Excel and XMLGenerating an XML FileApplying an XSL FileAutomating ExcelUsing the Web Browser Control7.3. Excel and OLE DBReading Excel Cell DataWHERE ClauseHeaders and Multiple RowsUPDATEInserting a New RowMixed Types7.4. Managed Data FeedA Managed "Live Data Feed" ComponentExcel VBA Client7.5. Real-Time Data in ExcelA Managed RTD ComponentA Stock Data ClassIRtdServer MethodsThe Excel Client7.6. Sinking Office EventsThe Core SolutionPrivate Sink Helpers (Pre–Office 2003)Tracking Cell ReferencesSummary

AppDomain Isolation8.1. The COM Shim WizardHow the Wizard Works8.2. Creating an Add-In Shim8.3. Creating a Smart Tag Shim8.4. Shim Wizard InternalsAdditional Shim Wizard FeaturesKnown Issues8.5. Config FilesCustom XML ParsingShimmed AppDomain ConfigsMultiple Configured Add-InsSummary
9.1. The SOAP ToolkitA Sample Web ServiceA Web Service ProxySOAP Toolkit CodeUDDI9.2. Managed Web Service Proxies9.3. WSE SecurityThe Core Add-InThe Web Service ProxyThe WSE Client ProxyThe WSE Web Service9.4. Research ServicesRaw SDK Research ServiceResearch Services Class Library9.5. Remoting with OfficeChatCoordinator SAOChat Server HostChat DelegateA WinChat ClientOfficeChat Add-In ClientSummary
10.1. VSTO Code-Behind Assemblies10.2. Custom Document Properties10.3. Debugging VSTO SolutionsClearing the Cached Shadow CopyAvoiding Swallowed Exceptions10.4. Word Code-BehindWord Document ProjectWord Template Project10.5. XML ListsImporting a List from XMLCreating a List Programmatically10.6. XML Data FormA Custom Command BarPopulating the List from SQL DataCreating an XSDBuilding a FormDynamic Queries10.7. VSTO and Web Services10.8. VSTO ConfigsSummary
11.1. Smart Documents CoreThe Initial ProjectDefining All ElementsDefining Each Element’s Task Pane ControlsPopulating Each ControlSpecifying Control BehaviorDeploymentTesting11.2. Multiple Target Applications11.3. Smart Documents and PIAs11.4. Vertigo Managed Smart Documents WrapperThe Initial ProjectControls and BehaviorA Variation for Word11.5. Smart Documents and Smart TagsSmart TagsSmart Document11.6. MOSTL Smart DocumentsSummary
12.1. Office Macro Security12.2. Code Access SecurityEvidenceSecurity PolicyPermissions12.3. VSTO SecurityUsing MSCorCfgUsing CASPolEncrypted Office DocumentsInformation Rights Management12.4. Strong-NamingDelay-SigningInitial Assembly and Delay-SigningStrong-Name Security EvidenceGAC-Deploying Code-Behind AssembliesStrong-Naming an ActiveX Control12.5. Authenticode CertificatesStrong-NamingAuthenticode SignaturesThe Publisher Code Group12.6. VSTO Deployment OptionsLocal Deployment ChangesAssembly Deployed to a Network ShareWorkbook Deployed to a Network ShareAssembly Deployed to a Web SiteUpdating VSTO SolutionsOfficeDocumentMembershipCondition12.7. Smart Document SecuritySummary