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.