Yesterday I received a couple of questions on how to build an application using Visual Studio 2005 Tools for Office together with Microsoft Excel. Just came accross this sample download on MSDN: Visual Studio 2005 Tools for Office Sample: Excel Invoice Application.
This sample solution introduces Microsoft Visual Studio 2005 Tools for the Microsoft Office System by demonstrating an Excel Invoice solution. The sample code covers the following topics:
- New Visual Studio 2005 Tools for Office design time experience
- New Named Range and List Object host controls
- New managed actions pane
- Windows Forms controls embedded in the Excel worksheet
The associated MSDN article - Building an Excel Invoice Application using Microsoft Visual Studio 2005 Tools for the Microsoft Office System - discusses the implementation process used to create the solution. C# and Visual Basic code snippets illustrate individual components of this Invoice application.
More info can also be found on the Visual Studio Tools for Office on the Office Developer Center.