Excel 2003 VBA Programming with XML and ASP

Designed to provide non-programmers with a hands-on guide to automating their spreadsheets through the use of Visual Basic for Applications, Excel 2003 VBA Programming with XML and ASP also gives readers a wide range of VBA coverage and a thorough overview of a number of programming languages and techniques useful for working with Excel. Learn how to: Work with macros, write VBA procedures and functions, use object collections, and create classes. Automate operations on files, folders, and other applications such as Microsoft Office Access. Enhance the user interface through the use of dialog boxes; custom forms, menus, and toolbars; and event-driven programming. Handle errors, debug procedures, and use e-mail in Excel. Program features such as PivotTables, PivotCharts, lists, and SmartTags, and control the Visual Basic Editor. Use Excel with a number of web technologies such as HTML, ASP, and XML.