Excel 97 Programming For Windows For Dummies

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.

The good news is that Microsoft Excel is out in a brand-new version with more features than ever before. The bad news is that this brand-new version contains plenty of new functions and commands to remember. So, to help you work productively with Excel 97 without being hindered by differences in its new functions, IDG Books Worldwide, Inc., presents Excel 97 For Windows For Dummies Quick Reference. In this book, you can find all the tips, shortcuts, commands, and quick solutions you need to get the most out of this latest update of your favorite spreadsheet software.

If you: need to process information quickly and accurately want to produce professional looking reports and presentations want to produce spreadsheets, charts and graphs need a self-teaching approachthen Excel 97 for Windows Made Simple is for you!By a combination of tutorial approach, with tasks to do and easy steps, the MADE SIMPLE series of Computer Books from British publisher Butterworth-Heinemann, using British authors and designed for a European audience, stands above all others.

It's all well and good for Microsoft to keep adding great new features to the world's most popular spreadsheet program; but if you can't figure out how to take advantage of them, then all's for naught. MORE Excel 97 For Windows For Dummies goes beyond Excel 97 For Windows For Dummies to show how to do things like create custom charts, use automatic subtotals, create templates, find and eliminate errors in your worksheets, run what-if analyses, create and edit macros to automate tasks, and exchange data with other Microsoft Office applications. Plus, author and Excel expert Greg Harvey reveals how to use exciting new features that convert Excel data and charts into Web pages.

Access 97 is finally out, and it has more than ever to offer even the most demanding database user. Find out just how much this popular program has to offer in Access 97 Programming For Windows For Dummies. This plain-English Access reference features in-depth, results-oriented coverage of all the newest Access capabilities. If you've never programmed Access before, you'll find Access 97 Programming For Windows For Dummies not only a quick and thorough primer to get you up to speed, but also a long-term resource you'll turn to again and again as you expand the functionality, performance, and ease-of-use of the databases you program. Plus, the companion CD-ROM contains two bonus chapters and lots of sample source code used throughout the book. With best-selling author Rob Krumm as your guide, you'll discover how to... * Build your own programs using the rich Access Basic programming language * Test code reliably and efficiently with Krumm's own foolproof methods * Deploy the power of SQL (Structured Query Language) to integrate multiple database sources * Harness the power of built-in Access features, such as OLE/DDE (Object Linking and Embedding/Dynamic Data Exchange) and Wizards that lead you step-by-step through many tasks * Create and distribute Access 97 applications by using the Microsoft Office 97 Developer Edition Tools (ODE Tools)

If you're ready to take the next step with Excel, then look no further. By using VBA (Visual Basic Application), you can discover a side of Microsoft Excel that most users never uncover. Excel 2000 Programming For Dummies introduces you to a wide array of new Excel options, including options for creating new worksheet functions; automating tasks and operations; creating new appearances, toolbars, and menus; and doing much more. First, you get well-acquainted with the most important tools and operations for the Visual Basic Editor; then, you get a quick overview of the essential elements and concepts for programming with Excel. Discover techniques for handling errors and exterminating bugs, the basics of working with range objects and controlling program flow, and much more. With friendly advice on the easiest ways to develop custom dialog boxes (also known as UserForms) and create custom toolbars and menus, you'll soon be creating the interfaces that best suit your unique needs. By the time you rip through Excel 2000 Programming For Dummies, you'll not only have maximized your macros, you'll have moved on to creating Excel applications with the best programmers on the block.

A "must have" book, this title shows Office 97 users how to get the most out of the HTML and ActiveX ready capabilities of the newest versions of Microsoft's most popular applications. Readers will be led step-by-step through implementing Office 97 documents on the Web.

Explains how to save and open workbooks, edit worksheets, use formulas and functions, create charts, and access the Internet.