About this title
	2nd edition (July 2003) 918 pages Publisher: apress Translator: David Kramer ISBN: 1590591038 Preis: $ 54.99
Content
	Includes a thorough introduction to the VBA language and the Excel object libraries Adresses the problems and pitfalls of Excel VBA - especially those not covered in Microsoft's online documentation - which advanced programmers face Covers advanced topcis that are often overlooked, such as automating graphs, pivot-tables, and data analysis; accessing external data using ADO; and using the file scripting objects (FSO-library) Explains how to automate repetitive tasks and build easy-to-use Excel applications Shows how to extend Excel Focuses on real-world applications Microsoft's Excel is not only a powerful spreadsheet and graphics tool - it contains a programming language called Visual Basic for Applications (VBA). VBA allows you to automate simple tasks, but also enables you to create full-featured applications that make Excel users more productive. In this book, Michael Kofler provides the definitive coverage of VBA for Excel by showing how it can be used to implement real-world business solutions. Designed to be useful to programmers who have never used VBA before, it nevertheless covers the advanced topics needed for users already familiar with VBA. This book first introduces VBA and shows examples of the kinds of tasks that can be performed. It then explains the Excel object model, focusing on the unique characteristics of programming and debugging code that is associated with a spreadsheet. The next few chapters cover menus, toolbars, forms and templates - the tools for creating customized user interfaces and full-featured applications. The book then moves on to a broad range of advanced topics, including automating graphs and diagrams, accessing external databases from Excel and analyzing data using grouping and pivot-tables. The book never loses sight of the real-world problems faced by programmers. It shows how to avoid undocumented or poorly documented problems that arise when programming Excel using VBA - the kind of practical knowledge gained through hard experience. The second edition has been completely updated and covers now Excel 2000, 2002 and 2003. New topics in the second edition are: Diagrams Using Smart Tags Accessing Web Services from Excel programs Processing lists and XML data (Excel 2003) Reference of all new objects added in Excel 2002 and 2003 A detailed table of contents is available as PDF (see next section).
Sample chapter and detailed TOC
	Detailed table of contents (150 KB, from apress.com) Chapter 10 on Charts and Drawing Objects (400 KB, from apress.com) Index (200 KB, from apress.com)
Sample files
	2nd edition (2003): The sample files are available for download at this apress book page. 1st edition (2000): The first printing of the book included a CD with all sample files. With the second printing, the CD has been removed. You can find all sample files at the apress book page. In case you have the first printing of the first edition, you should to download these updated/corrected sample files.
Errata
	Here is the errata page for the second edition. If you are still using the first edition, this old errata page for you!
Home
	Back home.