PROFESSIONAL Excel Development [Engels | Paperback | 2009]

Summary:
A guide to the development aspects of Excel covers such topics as building add-ins, creating custom charts, using class modules, handling errors, controlling external applications, and programming with databases.

As Excel applications become more complex and the Windows development platform more powerful, Excel developers need books like this to help them evolve their solutions to the next level of sophistication.

Professional Excel Development is a book for developers who want to build powerful, state-of-the-art Excel applications using the latest technologies.

If you're a working developer, no other book on Excel programming offers you this much depth, insight, or value.

Design worksheets that will be more useful and reliable
Leverage built-in and application-specific add-ins
Construct applications that behave like independent Windows programs
Make the most of the new Ribbon user interface
Create cross-version applications that work with legacy versions of Excel
Utilize XML within Excel applications
Understand and use Windows API calls
Master VBA error handling, debugging, and performance optimization
Develop applications based on data stored in Access, SQL Server, and other databases
Build powerful visualization solutions with Excel charting engine
Learn how to work with VB.NET and leverage its IDE
Automate Excel with VB.NET
Create managed COM add-ins for Excel with VB.NET
Develop Excel solutions with Visual Studio Tools for Office (VSTO)
Integrate Excel with Web Services
Deploy applications more securely and efficiently

Author:
Rob Bovey

Publisher : Addison Wesley; 1st edition (15 May 2009)
Language : English
Paperback : 1176 pages
ISBN-10 : 0321508793
ISBN-13 : 978-0321508799
Dimensions : 17.15 x 5.72 x 22.86 cm