Building Office Solutions with Visual Studio .NET

1
Building Office Solutions with Visual Studio .NET

• Anthony Vranic
• Microsoft Canada

2
Agenda

• Product Overview Demo
• Community Resources
• QA

3
VS .NET Office 2003

• Our goal Incorporate the richnessof Word and
  Excel 2003 with the benefits and advantages of
  Visual Studio .NET 2003
• Benefits
• Familiar user experience
• Large existing feature base
• Network-based deployment
• Built-in offline support via HTTP deployment

4
Visual Studio Tools for Office

• Extends .NET development to Microsoft Office 2003
• Smart client application development with Office
  2003 and the .NET Framework
• Developers using VS .NET 2003 can write code to
  run behind Word and Excel 2003 documents and
  workbooks
• Visual Basic .NET or Visual C
• This is not a replacement for VBA

5
How Does It Work?

• Designer or business expert creates and formats
  document and communicates requirements.
• Developer creates assembly, sets document
  properties, deploys assembly to centralized
  location.
• End users are notified, and open document.
• Office uses document properties to locate and
  download assembly.
• .NET security verifies assembly is OK to run.

6
Assembly Security

• Office High, Medium, Low macro dialog box dont
  apply to these assemblies.
• Assemblies governed by local machines .NET
  Framework 1.1 security policy.
• mscorcfg.msc (UI version)
• caspol.exe (command-line version)

7
Questions?
Go out and create those solutions!
8
Code Loading Process
User opens document
Unload AppDomain