Excel 2007 VBA Programming with XML and ASP

Introduction

This book shows you what’s doable with Microsoft Excel 2007 beyond the

standard user interface. If you ever wanted to open a new worksheet without

using built-in commands or create a custom, fully automated form to gather

data and store the results in a spreadsheet, you’ve picked up the right book.

This book shows you how to delegate many time-consuming and repetitive

tasks to Excel by using its built-in language, VBA (Visual Basic for Applica-

tions). By using special commands and statements and a number of Excel’s

built-in programming tools, you can work smarter than you ever thought

possible.

When I first started programming in Excel (circa ...