Excel 97 Programming for Windows^® For Dummies^®

This is the perfect guide for Programmers or "wannabe" programmers who need to get up to speed on the new features of Excel 97. -- Covers Excel 97, explaining all the new features and what they mean to programmers -- Provides the scoop on VBA - Visual Basic Applications and how its changed with the version of Excel -- Also covers the new Visual Basic Development Environment that provides tools to easily create custom solutions -- Shows users how to use ActiveX controls in their documents -- Describes macro programming fundamentals -- Explains objects properties, and methods -- Helps users use techniques to automate common tasks -- Shows users how to create custom worksheet functions to add power to worksheet formulas -- Find out about add-ins, Windows API and custom data types -- Includes a disk filled with codes so users don't waste time retyping For users who want to explore the wonderful world of Macros and make Excel do what they want using VBA! This book explains how to use VBA with Excel. It acquaints them with macro programming, providing them with an understanding of objects, properties, and more. It explains basic programming concepts so that users with no previous programming understand them. Then it moves on to the fun stuff like designing custom dialog boxes that look professional. It covers user interface topics, custom menus, and how to customize toolbars. This book makes it easier for developers to incorporate geographic mapping functionality into custom solutions. It's all here, updated to cover the hot new features in Excel 97!

---

By itself, Excel 97 can do some pretty amazing stuff. Add Visual Basic for Applications (VBA) and you add a whole other dimension of automation and customization. Excel 97 Programming For Windows For Dummies offers plenty of practical examples of Excel programming in action and explains in plain English how to
* Save time and improve accuracy by automating common tasks
* Design custom dialog boxes to suit your and your organization's needs
* Build specialized functions to use in your worksheets
* Create add-ins, take advantage of the Windows API, and define custom data types
With numerous books and articles on Excel to his credit, John Walkenbach is the ideal author to make Excel programming understandable, whether you're new to programming or just new to this latest release of Excel.

John Walkenbach has written hundreds of articles and numerous books, including Microsoft^® Excel 2000 Formulas. He is the principal of JWalk Associates, a spreadsheet application development company.