Home | Amazing | Today | Tags | Publishers | Years | Account | Search 
Professional Excel Development : The Definitive Guide to Developing Applications Using Microsoft(R) Excel and VBA(R)

Buy

Finally, there's a book that treats Excel as the powerful development platform it really is, and covers every facet of developing commercial-quality Excel applications.

This is not a book for beginners. Writing for professional developers and true Excel experts, the authors share insider's knowledge they've acquired building Excel applications for many of the world's largest companiesincluding Microsoft. Professional Excel Development demonstrates how to get the utmost from Excel, addressing everything from application architectures through worksheet and userform design, charting, debugging, error handling and optimizing performance. Along the way, the authors offer best practices for every type of Excel development, from building add-ins through interacting with XML Web services. Coverage includes

  • Building add-ins to provide new Excel functions

  • Designing effective worksheets, userforms and other user interface elements

  • Leveraging Excel's powerful data analysis features

  • Creating sophisticated custom charts

  • Handling errors, debugging applications and optimizing performance

  • Using class modules and interfaces to create custom objects

  • Understanding Windows API calls: when to use them, and how to modify them

  • Adding worksheet functions with C-based XLLs

  • Programming with databases

  • Controlling external applications from Excel

  • Integrating with Visual Basic 6, VB.NET and Visual Studio Tools for Office

  • Using XML to import and export data and communicate with Web services

  • Providing help, securing, packaging and distributing

The accompanying CD-ROM contains the book's sample timesheet application at every stage of construction, with detailed code comments. It also includes many examples of the concepts introduced in each chapter and a collection of the authors' Excel development utilities.

(HTML tags aren't allowed.)

Do Smart Adaptive Systems Exist?: Best Practice for Selection and Combination of Intelligent Methods
Do Smart Adaptive Systems Exist?: Best Practice for Selection and Combination of Intelligent Methods

Do Smart Adaptive Systems Exist? is intended as a reference and a guide summarising and focusing on best practices when using intelligent techniques and building systems requiring a degree of adaptation and intelligence.

It is therefore not intended as a collection of the most recent research results, but as a practical...

Composition in Convergence : The Impact of New Media on Writing Assessment
Composition in Convergence : The Impact of New Media on Writing Assessment
This book attempts to explore what these tensions are as writing
assessment and computer technology converge on classroom
space. However, I can make no promises that this examination of
the issues can resolve the tensions. Perhaps no amount of study can
resolve the tensions that exist. The difficulties span political,
...
MUD Game Programming (Game Development)
MUD Game Programming (Game Development)

Develop your own Multi-User Dungeon games! Multi-User Dungeon games are still going strong. It's no wonderthey're easy to create and easy to access. They also have an additional appeal for game programmersthey serve as the foundation for today's Massively Multiplayer Online Role Playing Games. In order to create an MMORPG,...


Electroconvulsive Therapy
Electroconvulsive Therapy
In this fully-revised fourth edition of what has long been the standard textbook for the field, Dr. Richard Abrams once again demonstrates his unique ability to analyze and present a wealth of new(and often technical) material in a lucid, compelling, and highly readable fashion. Hundreds of new clinical studies called from the more than 1500...
Perl Power!: A JumpStart Guide to Programming with Perl 5
Perl Power!: A JumpStart Guide to Programming with Perl 5

After the two successful years that this book has been available in German-speaking countries, the publishers decided to translate it into English and allow me the opportunity to address not only my German countrymen but savvy Perl programmers throughout the world!

This book has come a long way since it was first published: it was...

Expert .NET Micro Framework, Second Edition
Expert .NET Micro Framework, Second Edition
The Microsoft .NET Micro Framework is a small and efficient .NET runtime environment used to run managed code on devices that are too small and resource constrained for Windows CE and the Compact Framework.

Expert .NET Micro Framework will teach you everything you need to know to use the .NET Micro Framework to create effective...

©2020 LearnIT (support@pdfchm.net) - Privacy Policy