Managed Code in an Excel Project

We are going to look at two examples of running managed code in Excel. In our ActiveX examples, we revisited some of the functionality we'd already built directly in Excel using VBA. The first example .NET project will duplicate some of the functionality from our previous VBA projects, but you'll see how the .NET versions require absolutely no code on the Excel client workbook. Our second example will show how to create a custom task pane in an Excel 2007 Add-in project in conjunction with the .NET version of an Excel UserForm.

Caution If you do not have Visual Studio 2005, you can still run the sample workbooks as long as you have placed the Northwind 2007.accdb file in the same path that the sample code refers to. The only other prerequisite is that the .NET Framework 2.0 must be installed on your PC.

0 0

Post a comment