MS Excel 2002 VBA/XML Programming and ASP

Designed to provide non-developers with a hands-on guide to Excel Visual Basic for Applications, Learn Microsoft Excel 2002 VBA Programming with XML and ASP gives users a wide range of VBA coverage, along with an introduction to the Extensible Markup Language and Active Server Pages technologies.

* Quickly learn how to program by utilizing the built-in macro recorder.

* Add decision making and repetition to your procedures.

* Control other applications from within Excel through Automation.

* Create and customize user forms, menus, and toolbars.

* Learn how to handle errors and debug your programs by using built-in debugging tools.

* Perform Microsoft Access tasks from within Excel.

* Discover how to put Excel data on a web page and retrieve data from the web into an Excel worksheet.

* Work with Excel spreadsheets saved in XML format.

* Program special features such as the Microsoft Office XP PivotTable and PivotChart web components.

* Learn how to use a number of objects from the Excel 2002 and Office XP Object Models.

ON THE CD:The companion CD-ROM contains example files discussed in the book.


Summary: Highly impressive
Rating: 4

What a delight to be able to actually "read" a book on VBA.
The writer is lucent and accessible and does not try to con you into the belief that VBA is a 15 hr.learning curve. Explanations are clear and the text will serve as an excellent reference source for years to come.
Watch out Mr Spreadsheet/Mr Excel here is a writer who not only knows her subject inside out but is able to impart this knowledge in a painless fashion that others simply cannot!