Visual Basic (VB), Network Programming, Spreadsheets, General Web Site Design/Development, XML, SGML, & Other Document Mark-up Languages, Microsoft Excel, General Software Engineering, Web Programming

Excel 2007 VBA Programming with XML and ASP

Name: Excel 2007 VBA Programming with XML and ASP
Author: Julitta Korol
ISBN: 9781598220438

by Julitta Korol

Available on Bookshop Write a review

Books.org participates in affiliate programs including Bookshop.org and the Amazon Services LLC Associates Program. We may earn a commission from qualifying purchases made through links on this page, at no additional cost to you.

Overview

Excel 2007 Programming by Example with XML and ASP offers a hands-on approach for those looking to extend and customize Excel functionality. From recording a simple macro and writing VBA code to working with XML documents and using ASP to accss and display data, this book takes you on a progrmming journey that will change the way you work with Excel.
Learn how to automate spreadsheet tasks with macros; write VBA code to program PivotTables, generate charts, build dialog boxes, and customize the Ribbon; handle errors and debug programs; create hyperlinks and publish HTML files.
Retrieve data from the web directly into Excel; develop and manipulate smart tags using XML.

Synopsis

This book takes non-programmers through detailed steps of automating their spreadsheets. It demonstrates hands-on the use of VBA language concepts. This book takes users all the way to the Web: Creating hyperlinks with VBA, creating and publishing HTML files, web charting, and using web queries to import web data.