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.)

The Oxford Handbook of Ethics and Economics
The Oxford Handbook of Ethics and Economics
Economics and ethics are both valuable tools for analyzing the behavior and actions of human beings and institutions. Adam Smith, the father of modern economics, considered them two sides of the same coin, but since economics was formalized and mathematicised in the late 1800s and early 1900s, the fields have largely followed separate...
DarkMarket: Cyberthieves, Cybercops and You
DarkMarket: Cyberthieves, Cybercops and You

"This extraordinarily powerful book demonstrates how utterly we lack the shared supranational tools needed to fight cybercrime. Essential reading." --Roberto Saviano, author of Gommorah

The benefits of living in a digital, globalized society are enormous; so too are the dangers. The world has become a
...

The Theory of Matrices in Numerical Analysis
The Theory of Matrices in Numerical Analysis
This book represents an effort to select and present certain aspects of the theory of matrices that are most useful in developing and appraising computational methods for solving systems of linear equations (including the inversion of matrices) and for finding characteristic roots. The solution of linear inequalities and the problems of linear...

Digital Watermarking and Steganography, 2nd Ed. (The Morgan Kaufmann Series in Multimedia Information and Systems)
Digital Watermarking and Steganography, 2nd Ed. (The Morgan Kaufmann Series in Multimedia Information and Systems)
Digital audio, video, images, and documents are flying through cyberspace to their respective owners. Unfortunately, along the way, individuals may choose to intervene and take this content for themselves. Digital watermarking and steganography technology greatly reduces the instances of this by limiting or eliminating the ability of third parties...
Windows 8.1 Step by Step
Windows 8.1 Step by Step

The smart way to learn Windows 8.1—one step at a time!

Experience learning made easy—and quickly teach yourself how to navigate and use Windows 8.1. With Step by Step, you set the pace—building and practicing the skills you need, just when you need them!

Mathematics As a Science of Patterns
Mathematics As a Science of Patterns
This book expounds a system of ideas about the nature of mathematics which Michael Resnik has been elaborating for a number of years. In calling mathematics a science he implies that it has a factual subject-matter and that mathematical knowledge is on a par with other scientific knowledge; in calling it a science of patterns he expresses his...
©2021 LearnIT (support@pdfchm.net) - Privacy Policy