Everything you need to know about:

• Creating stellar UserForms and custom dialog box alternatives
• Working with VBA subprocedures and function procedures
• Incorporating event-handling and interactions with other applications
• Building user-friendly toolbars, menus, and help systems
• Manipulating files and Visual Basic® components
• Understanding class modules
• Managing compatibility issues

Feel the power of VBA and Excel

No one can uncover Excel’s hidden capabilities like "Mr. Spreadsheet" himself. John Walkenbach begins this power user’s guide with a conceptual overview, an analysis of Excel application development, and a complete introduction to VBA. Then, he shows you how to customize Excel UserForms, develop new utilities, use VBA with charts and pivot tables, create event-handling applications, and much more. If you’re fairly new to Excel programming, here’s the foundation you need. If you’re already a VBA veteran, you can start mining a rich lode of programming ideas right away.

CD-ROM Includes

• Trial version of the author’s award-winning Power Utility Pak
• Over one hundred example Excel workbooks from the book

System Requirements: PC running Windows® 2000 SP3 or later, or Windows XP™ or later. microsoft Excel 2003. See the "What’s on the CD" Appendix for details and complete system requirements.

Book Info
Guide to Excel VBA, showing how to create UserForms and custom dialog box alternatives, working with VBA subprocedures and function procedures, managing compatibility issues, and more. Softcover.

Professional Ajax discusses the range of request brokers (including the hidden frame technique, iframes, and XMLHttp) and explains when one should be used over another. You will also learn different Ajax techniques and patterns for executing client-server communication on your web site and in web applications. By the end of the book, you will have gained the practical knowledge necessary to implement your own Ajax solutions. In addition to a full chapter case study showing how to combine the book's Ajax techniques into an AjaxMail application, Professional Ajax uses many other examples to build hands-on Ajax experience. Some of the other examples include:

• web site widgets for a news ticker, weather information, web search, and site search
• preloading pages in online articles
• incremental form validation
• using Google Web APIs in Ajax
• creating an autosuggest text box

This book discusses the range of request brokers (including the hidden frame technique, iframes, and XMLHttp) and explains when one should be used over another. You will also learn different Ajax techniques and patterns for executing client-server communication on your web site and in web applications. Each chapter builds on information in the previous chapters so that by the end of the book, you will have gained the practical knowledge necessary to implement your own Ajax solutions.

What you will learn from this book

• Different methods for achieving Ajax communication and when to use each
• A variety of Ajax design patterns to use in specific data retrieval circumstances
• Techniques for using Ajax with RSS and Atom to produce a web-based news aggregator
• How to use JavaScript Object Notation as an alternate data transmission format for Ajax communications
• How to create Ajax widgets, such as a weather display and news ticker, that can be included in your web site

Who this book is for

This book is for web developers who want to enhance the usability of their sites and applications. Familiarity with JavaScript, HTML, and CSS is necessary, as is experience with a server-side language such as PHP or a .NET language.

Wrox Professional guides are planned and written by working programmers to meet the real-world needs of programmers, developers, and IT professionals. Focused and relevant, they address the issues technology professionals face every day. They provide examples, practical solutions, and expert education in new technologies, all designed to help programmers do a better job.

After a quick tour of CORBA basics, the authors jump right in with a minimum skeleton application written in C++. From there, they provide truly extensive coverage of CORBA IDL, along with many tips for using IDL data types in C++. (They cover advanced features such as any, TypeCode, and DynAny later in the book.).

Next the book unveils its sample application--a distributed climate control system. Material on the Portable Object Adapter and the Object Life Cycle, including garbage collection strategies, rounds out this section. Additional chapters examine the details of Object Request Brokers (ORBs), including Internet Inter-ORB Protocol (IIOP), repositories, and binding. The authors also present CORBA's built-in APIs for Naming, Trading, and Event Services (including asynchronous event handling), which is most useful as reference material.

Final sections examine strategies for better scalability, including multithreading and optimizing network traffic for CORBA objects. The authors provide numerous short excerpts of C++ code, though it must be said that much of this book is reference material rather than a hands-on programming tutorial. --Richard Dragan

Jon Biggar, Floorboard Software
It's positively great. We finally have something that actually covers the topic from the point of view of the standard, rather than a proprietary implementation.