Excel Add-in Development In C/C++: Applications In Finance

by Steve Dalton (Eignesys Ltd, UK)

• ISBN13: 9780470024690
• ISBN10: 0470024690
• Edition: CD
• Format: Hardcover
• Copyright: 2004-12-01
• Publisher: WILEY

Summary

Excel is the industry standard for financial modelling, providing a number of ways for users to extend the functionality of their own add-ins, including VB. C/C++. Excel Add-in Development in C/C++ - Applications for Finance is a how-to guide and reference book for the creation of high performance add-ins for Excel in C and C++ for users in the finance industry. Author Steve Dalton explains how to apply Excel add-ins to financial applications with many examples given throughout the book. It covers the relative strengths and weaknesses of developing add-ins for Excel in VB versus C/C++."This book is for anyone who wants to do any application development in Excel. Even for an old hand at Excel development such as myself, a brief skim through reveals valuable nuggets of information. Delving deeper into the text, richer veins are easily found. This book is destined to become an essential reference on Excel development." Dr. Les Clewlow, Principal, Lacima Group Ltd."Programming Excel add-ins using the C API can be complex and difficult. Steve has done a masterful job of demystifying the process. After reading this book you'll be creating XLLs for all purposes with complete confidence. Highly recommended." Rob Bovey, MCSE, MCSD, Excel MVP, President, Application Professionals

Table of Contents

Preface.

Acknowledgements.

1 Introduction.

2 Excel Functionality.

3 Using VBA.

4 Creating a 32 Bit Windows (Win32) DLL Using Visual C++ 6.0 or Visual Studio .Net.

5 Turning DLLs into XLLs: The Add-in Manager Interface.

6 Passing Data Between Excel and the DLL.

7 Memory Management.

8 Accessing Excel Functionality Using the C API.

9 Miscellaneous Topics.

10 Example Add-ins and Financial Applications.

References.

Web links and other resources.

Index.