An exploration of the relationship between XML and Office 2003, examining how the various products in the Office suite both produce and consume XML. Beginning with an overview of the XML features included in the various Office 2003 components, it provides guidance on how to import or export information from Office documents into other systems.

* Edit standard XML files with all the tools of Word and Excel (like formulas and the spell checker) * Take existing Word or Excel documents, transform all or part of them into XML, and "plug" them into business processes. * Mine the data in an Office document, using custom macros or applications—on any platform. * Create rich Word or Excel documents programmatically, without even needing to have Office installed. * Create smart documents that have built-in user guidance and validation rules to prevent errors.

Covers the new features, tools, and technologies in Office 2003 and demonstrates how developers can extend, enhance, and customize the suite using VisualBasic for Applications (VBA) More than 800 pages of clear and friendly For Dummies advice and instructions help developers get up to speed fast, improve workflow, and get the job done Packed with helpful real-world examples, including creating an Office document collaboration manager, automating e-mail routing, administering the Task Pane from within an application, and building a distributed business system using Web services The eight minibooks cover Office 2003 essentials; understanding Office programming; maximizing Word; making the most of Excel; advanced Access; exploiting Outlook; InterOffice; working as a team; and power techniques such as advanced Office automation, VBA, and .NET

Presents a guide to the applications found in Microsoft Office, including Excel, Access, Word, PowerPoint, and Outlook.

On the surface, it doesn't appear as if much in Excel 2003 has changed. There are a handful of new objects and the user interface is largely the same. But beyond a superficial glance, you'll see that there are fundamental shifts implied by the new features: Lists, XML, web services, .NET, and InfoPath build a framework for entirely new ways to exchange data with Excel. In fact, that's much of what Excel 2003 is all about--solving problems that deal with teamwork-- collecting and sharing data, programming across applications, and maintaining security.The latest in our Developer's Notebook series, this guide introduces intermediate to advanced Excel VBA programmers to the newest programming features of Excel 2003,--focusing just on what's new--so you can get up to speed quickly. Light on theory and long on practical application, the book takes you directly to the topics you'll want to master through a series of hands-on projects. With dozens of practical labs, you'll be able to decide for yourself which new aspects of Excel will be useful or not in your own work. And best of all, you won't have to buy an expensive revision of a legacy Excel programming tutorial to learn about the new features--if they're covered there at all.Excel 2003 Programming: A Developer's Notebook shows you how to work with lists and XML data, secure Excel applications, use Visual Studio Tools for Office, consume Web Services, and collect data with Infopath. Each chapter is organized into a collection of labs, each of which addresses a specific programming problem. You can follow along to complete the lab on your own, or jump ahead and use the samples the author has built for you.The new Developer's Notebooks series from O'Reilly covers important new tools for software developers. Emphasizing example over explanation and practice over theory, they focus on learning by doing--you'll get the goods straight from the masters, in an informal and code-intensive style that suits developers. If you've been curious about Excel 2003, but haven't known where to start, this no-fluff, lab-style guide is the solution.

Microsoft Office 2003 provides a powerful integrated suite of programs with which to create and share documents and presentations, communicate, and analyze business information. It takes advantage of the latest technologies such as XML and Microsoft SharePoint to extend desktop productivity and workspace collaboration over an intranet or the Internet. This visual book covers these changes and all other important features of the Office system in a format that is easy for new users to get working quickly and upgrading users to learn what's different in this version. Other features of the book include a "Troubleshooting Guide" to help solve common problems, a "Project Guide" with a listing of real-world projects by feature, and a "MOS Exam Guide" with a complete listing of MOS objectives. This provides a definite advantage over the competition, since no other visual book offers this feature. Topics covered in this book are Word, Excel, PowerPoint, Access, Outlook, Publisher, creating web pages with Office, sharing information within Office Docs, collaboration with Office, and InfoPath 2003.

Developers and system administrators alike are uncovering the true power of XML, the Extensible Markup Language that enables data to be sent over the Internet from one computer platform to another or one application to another and retain its original format. Flexible enough to be customized for applications as diverse as web sites, electronic data interchange, voice mail systems, wireless devices, web services, and more, XML is quickly becoming ubiquitous.XML Hacks is a roll-up-your-sleeves guide that distills years of ingenious XML hacking into a complete set of practical tips, tricks, and tools for web developers, system administrators, and programmers who want to go far beyond basic tutorials to leverage the untapped power of XML.With plenty of useful real-world projects that illustrate how to define, read, create, and manipulate XML documents, XML Hacks shows readers how to put XML's power to work on the Internet and within productivity applications. Each Hack in this book can be read easily in a few minutes, saving programmers and administrators countless hours of searching for the right answer. And this is an O'Reilly Hacks book, so it's not just practical, imminently useful, and time-saving. It's also fun.From Anatomy of an XML Document to Exploring SOAP Messages XML Hacks shows you how to save time and accomplish more with fewer resources. If you want much more than the average XML user--to explore and experiment, do things you didn't know you could do with XML, discover clever shortcuts, and show off just a little--this invaluable book is a must-have.

* Builds real applications that can be customized and used commercially. * Provides real-world examples, each of which offers a fundamental lesson in approaching data structure and code. * Friendly, open and targeted chapters that can be absorbed one lesson at a time.

Microsoft Office 2003 is the sixth version of Microsoft's best-selling Office suite. As such, most of the audience is comprised of people who have used previous versions of Office and are quite familiar with most of the features. Upgraders do not need a 800-page book that covers every aspect of every Office application. They need a book that's focused only on what's new, so that they can move forward with a minimum of fuss. That's what this book is all about.

Excel Annoyances addresses the quirks, bugs, and hidden features found in the various versions of the Excel spreadsheet program. Broken down into several easy-to-follow categories such as Entering Data, Formatting, Charting, and Printing, it uncovers a goldmine of helpful nuggets that you can use to maximize Excel's seemingly limitless potential.