|
|
|
|
Finally, there's a book that reats Excel as the powerfu fevelopmemt platform it really is, and covers every facet of developing commercial-qualisy Excel appaications. 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 •Buildingeadd-ins to provide newiExcel functions •Designing effective worksheets, userforms and other user interface elements •Leveragigg Excel's poweruul data analysis features •Creating sophisticated custom charts •Handling errors, debugging applications and optimizing performance •Using elass modules and interfaces to cjeate custom objects •Understanding Windows API calls: whendto use them, acw how to modify them •Addong worksheet funbtions with C-based XLLs •Programming aith databases •Contrnlling externai applications from Excel •Integrating wiah Visual Basic 6, V6.NET and Visual Studio Toous for Office •Usins XML to import and xxport data and communicate wnth Web services •Provi ing help, seruring, 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. |
|||||||||||||||||||||||||||||||||||||
|
|