Light on theory and long on practical application, this guide takes you directly to Excel 2003's new features using a series of hands-on projects. Learn to work with lists and XML data, secure Excel applications, use Visual Studio Tools for Office, consume Web Services, and collect data with Infopath. If you've been curious about Excel 2003, but haven't known where to start, this book is the solution.
There are a number of books that include good introductions to programming Excel, but this is not one of them. I assume a couple of things about you: the first is that you're already somewhat familiar with Excel and Visual Basic; the second is that you've got a programming problem to solve.
Excel 2003's new features solve problems dealing with teamwork: collecting and sharing data, programming across applications, and maintaining security. In researching this book, I noticed that most of the newly published Excel books touch on these topics but don't explore them in depth or put them in context. So that's where I focus my efforts.
Each chapter is organized into a collection of labs, each of which addresses a specific programming problem. You can follow along in the text to complete the lab on your own, or you can jump ahead and use the samples I've built for you. Often one lab builds on another, so it's a good idea to skim earlier sections if you are jumping ahead in a chapter.
I don't expect this book will be your only resource, so I include a lot of references in each chapter. I've also included those references as hyperlinks in the sample workbooks (see the Resources sheet). Mostly those links deal with very specific issues related to the topic, but they also include links to toolkits and other software that may be required.