With the XML advantages in the Office 2003 suite of applications not being glaringly obvious (at least not to me), I gave this book a whirl. I’m glad I did.

It’s consistent in its organization – presenting the capabilities of Word, Excel, Access, FrontPage, and Office forms to use, manage and manipulate XML-based data – first from within the applications themselves, and then from more robust subsystems using Office’s embedded Visual Basic for Applications (VBA). It shows how easy it is to manage data by building great apps with simple scripts. (Notably missing was a discussion on the applications of XML within PowerPoint, although I’m admittedly unsure if that’s even an issue.)

The book’s voice is very friendly and non-intimidating, using chapter around 15-30 pages at most, making for a pleasant, quick reading experience. On this note, I found the Excel chapters and those on WordML especially valuable. As far as the examples themselves, all were practical and easy to replicate locally, whether by menu or through code. There’s a healthy lean towards the use of SOAP by making Web services calls for importation of data that’s a great addition.

The book also has something I found that many modern programming texts don’t – an easy-to-understand explanation of schemas and how to construct them. All books discussing XML obviously make mention of the use of schema, but the vast majority don’t explain it well. The authors do a great job of not only explaining schema’s role in an app, but also how to build it, which is something newbies will appreciate.

Still, in this day of modern distributed applications and datashaping, I also would have liked to see the VBA-based examples complemented/contrasted with .NET programming concepts and code, working against the APIs for each Office app. Also, one thing I found somewhat annoying was that the code, while complete and hearty, always referenced “in Line 25...and then in Line 30”, without marking the lines of code, forcing the reader to manually count-and-mark the lines. This was a minor nuisance, but a nuisance nonetheless.

But the good in this book far outweighs the bad, and the content and examples can be picked up by any level of staffer in the workplace who’s familiar with Office apps. It’s a great read.