Book Categories

Description of Excel Add–in Development in C/C++

Excel Add–in Development in C/C++: Applications in Finance is a must–buy book for any serious Excel developer. 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++. This is the only complete 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. Steve Dalton explains how to apply Excel add–ins to financial applications with many examples given throughout the book. It also covers the relative strengths and weaknesses of developing add–ins for Excel in VB versus C/C++, and provides comprehensive code, workbooks and example projects on the accompanying CD–ROM. Excel Add–in Development in C/C++ features:

• Extensive example codes in VB, C and C++, explaining all the ways in which a developer can achieve their objectives.
  
  
• Example projects that demonstrate, from start to finish, the potential of Excel when powerful add–ins can be easily developed.
  
  
• Develops the readers understanding of the relative strengths and weaknesses of developing add–ins for Excel in VB versus C/C++.
  
  
• A CD–ROM with several thousand lines of example code, numerous workbooks, and a number of complete example projects.
  

Title Information

ISBN:

9780470024690

Pages:

422 pages

Format:

Hardback

Product Code:

20387

Publisher:

John Wiley & Sons Ltd

Published:

26/10/2004

Press and Industry Reviews

"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

Write a review of this book

Customer Reviews from Amazon

About Steve Dalton

STEVE DALTON is currently head of Exotic Options at Collins Stewart Tullett plc in London. Steve has almost 20 years of experience working in the fields of interest rate derivatives and IT. With a background in mathematics and computing, he pioneered the use of real–time spreadsheets in the mid 1980s for arbitrage and derivatives pricing. He founded Eigensys Ltd in the late 1980s, which specialises in software and consultancy in this field and in the use of Excel for demanding real–time applications.

Contents of Excel Add–in Development in C/C++

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