|
Excel 2003 VBA Programming with XML & 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.
The example files for the hands-on activities can be downloaded from www.wordware.com/files/excel2003.
Introduction to Excel 2003 VBA programming
Manipulating files & controlling other applications with VBA
Enhancing the user interface
Debugging & printing
Programming special features
Excel & web technologies
|
