MS Excel 2002 VBA/XML Programming and ASP
Wordware Publishing, Inc. | Pages: 716 | 2002 | ISBN 1556227612 | PDF | 14 MB
Wordware Publishing, Inc. | Pages: 716 | 2002 | ISBN 1556227612 | PDF | 14 MB
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!