This article describes an All-In-One Code Framework sample that is available for download. This code sample includes a step-by-step guide about how to use the Excel Automation Addin to create user defined formulas for Microsoft Office Excel. The All-In-One Code Framework samples in this KB article show you how to develop an Excel Automation Addin by using Visual C#.NET and Visual Basic.NET.
To download this code sample, click the following link:
Developers can use Excel Automation Addin to create user defined formulas for Excel. The Automation Addin is a COM component. After the COM component is registered on the target computer, Excel can load and access this Automation Addin's UDF (user defined formulas). To do this, follow these steps:
In Excel, click the Microsoft Office Button, and then click Excel Options.
Under Manage, click Excel Add ins, and then click Go.
In the Add-Ins dialog box, click Automation. In the list of registered COM servers, click your automation Add-in, and then click OK.
The automation Add-in appears in the Add-ins dialog box. Then, click OK to close the Add-Ins dialog box.
All-In-One Code Framework samples in this KB article show you how to develop an Excel Automation Addin by using Visual C#.NET and Visual Basic.NET. To use these samples, you can open them in Microsoft Visual Studio 2008, and then compile the project. When the project is compiled, the output dll is registered as a COM component. Then, you can follow the above instructions to load and access the automation Addin in Excel.
Note For more information about how to create the sample application and how to deploy the sample application, see the Readme.txt file that is included in the download package.
Office Solution Development
This code sample contains the following programming languages:
Visual Basic .NET
This sample application was created by using Visual Studio 2008 with Service Pack 1 installed.
Excel, Automation AddIn
What is All-In-One Code Framework?
All-In-One Code Framework shows most Microsoft development techniques by using code samples in different programming languages. Each example is carefully selected, composed, and documented to show one common code scenario. For more information about All-In-One Code Framework, visit the following Web site: http://cfx.codeplex.com
How to find more All-In-One Code Framework samples
Microsoft corporation and/or its respective suppliers make no representations about the suitability, reliability, or accuracy of the information and related graphics contained herein. All such information and related graphics are provided "as is" without warranty of any kind. Microsoft and/or its respective suppliers hereby disclaim all warranties and conditions with regard to this information and related graphics, including all implied warranties and conditions of merchantability, fitness for a particular purpose, workmanlike effort, title and non-infringement. You specifically agree that in no event shall Microsoft and/or its suppliers be liable for any direct, indirect, punitive, incidental, special, consequential damages or any damages whatsoever including, without limitation, damages for loss of use, data or profits, arising out of or in any way connected with the use of or inability to use the information and related graphics contained herein, whether based on contract, tort, negligence, strict liability or otherwise, even if Microsoft or any of its suppliers has been advised of the possibility of damages.
Microsoft Visual Studio 2008 Academic Edition, Microsoft Visual Studio 2008 Professional Edition, Microsoft Visual Studio 2008 Standard Edition, Microsoft Visual Studio Team System 2008 Database Edition, Microsoft Visual Studio Team System 2008 Architecture Edition, Microsoft Visual Studio Team System 2008 Development Edition, Microsoft Visual Studio Team System 2008 Test Edition, Microsoft Visual Studio Team System 2008 Team Suite, Microsoft Office Excel 2007