Excel 2003 VBA Programming with XML and ASP - Softcover

Korol, Julitta

Softcover

ISBN 10: 1556222254 ISBN 13: 9781556222252

Publisher: Wordware Publishing Inc., 2005

Synopsis

Users learn event programming, debugging as well as how to port their work to the Web using VBScript, HTML, ASP, and XML.

About this title

Synopsis

This title available in a book and CD format. It takes non-programmers through detailed steps of automating their spreadsheets. The book begins with recording a simple macro and exploring its code and proceeds to demonstrating in hands-on exercises the use of VBA language concepts. After readers have mastered decision making, looping, and the usage of collections and arrays, they quickly move on to perform automating operations on files, folders, and other applications such as Word or Access. And that's not all.Readers also learn how to write VBA code to program pivot tables, generate charts, build dialog boxes, and design and customize menus and toolbars. They learn event programming and ways to handle errors and debug their programs. Some books finish at this point, however, this book goes on further - all the way to the Web: creating hyperlinks with VBA, publishing worksheets, web charting, and using web queries to import web data. Using VBScript, HTML, Active Server Pages, and Extensible Markup Language is introduced step-by-step. It includes CD with downloadable files which include all the book's hands-on exercises and custom projects.

Edition details

• Publisher: Wordware Publishing Inc.
• Publication date: 2005
• Language: English
• ISBN 10: 1556222254
• ISBN 13: 9781556222252
• Binding: Paperback
• Number of pages: 948