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++. qThis 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.q Dr. Les Clewlow, Principal, Lacima Group Ltd. qProgramming 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.q Rob Bovey, MCSE, MCSD, Excel MVP, President, Application Professionals0 The interim data are in full view of the spreadsheet user; a problem if they are private or confidential. 1. ... if the structurea#39;s data do need to be accessed, the DLL can export access functions that can get (and set) values indirectly. ... clearing up of resources in the event that a formula for MakeArray gets deleted or overwritten or the workbook gets closed. ... and recalculations are handled properly by Excel, although it can only be used as a trigger, not a reference to the data structure.
|Title||:||Excel Add-in Development in C/C++|
|Publisher||:||Wiley - 2004-12-15|