Developing Applications With Microsoft Office

The complete handbook for PC support professionals developing and implementing business applications using Microsoft Office and Visual Basic. With a special focus on using DDE and OLE to create integrated applications for a wide variety of business uses, this book provides unique insight into the process of designing, maintaining, and supporting applications built using Microsoft Office Professional.

Get fully functional database samples and table designs for four of the most common Microsoft Access database types--and use them as templates to create your own Access solutions. Database expert and Microsoft MVP John L. Viescas provides the detailed guidance you need to customize your own solutions from these application types: Membership Tracking Inventory Management Customer Support Reservations Management For each type, you'll walk through typical usage scenarios, design considerations, and common pitfalls. You'll examine the logic behind each application's table design, and learn how to adapt it for your own Access solution. Get expert insights and examples to help you: Learn specific design techniques to improve your table structures Build forms with an attractive, intuitive, and easy-to-use interface Create queries, forms, and reports specific to each application type Design for client/server from the start'and share data more efficiently Apply best practices to help your application run more smoothly Avoid the 10 most common design problems--and deliver more robust solutions! Note: This book covers Microsoft Office Access 2003, Access 2002, and Access 2000 CD includes database samples and a fully searchable eBook. Use the sample databases on CD to model your own solutions for: Membership Tracking: Enter, track, and manage member information and communications. Inventory Management: Track and manage stock and create purchase orders, invoices, and packing lists. Customer Support: Track contacts, enter customer details, identify follow-up items, and create reminders. Reservations Management: Manage course registrations, car rentals, room reservations, and more. For customers who purchase an ebook version of this title, instructions for downloading the CD files can be found in the ebook.

The definitive guide to developing applications with Microsoft Excel, this book is written by four authors who are Excel MVPs and run their own companies developing Excel-based applications.

This comprehensive handbook teaches you how to use the programming tools in Microsoft Excel, Access, Word, and PowerPoint to build and maintain powerful, elegant business applications. Abundant sample code and more than a dozen fully functional sample applications, built with Office products and Microsoft Visual Basic, are included. More than just a primer on writing Office-based applications, the book covers strategies for the design and development of mission-critical applications; integration issues; and end-user training, presentation, and documentation.

Create Microsoft Office-based applications that work seamlessly in the Microsoft .NET environment--with this essential reference from Microsoft developer Andrew Whitechapel. The author provides expert advice on the various approaches you can use to build managed solutions with Office, and gives practical guidance on the most viable techniques for technical and business scenarios. You'll begin building custom .NET-based applications with detailed, practical exercises that take you through solutions from beginning to end. Andrew shares tactics, strategies, and best practices--plus full sample code--to help you maximize your development efforts. Packed with the same information used by Microsoft's Product Support Services team, this book is the one reference that every Office and .NET developer should have. Discover how to: Develop powerful .NET solutions for Office with managed interop assemblies Integrate managed code with Microsoft Visual Basic for Applications (VBA) Create custom commands and functionality with managed COM and Automation add-ins Build custom Office features with external data using Web services, .NET remoting, and research services Use Microsoft Visual Studio Tools for Office to create document-centric solutions for Microsoft Excel and Word Use digital signatures, strong-naming and .NET Code Access Security Control Office applications using Platform Invoke, Reflection, drag-and-drop, and the IAccessible interface Develop managed Smart Tags and managed Smart Document solutions Covers Microsoft Office 97, Office 2000, Office XP, and Microsoft Office System 2003 Editions

"This is the 'must have' book for programming with Outlook and CDO. This book provides the details, tips, and cautions that can save you time and frustration when building collaborative applications. So if you like 'the best' in your technical library, get this book." --Deborah Kurata, InStep Technologies, Inc. Written for IT developers who build collaborative and workflow applications, this book provides a comprehensive reference to working with Microsoft's powerful collaborative development environment, including Outlook 2000, Exchange Server, Visual Basic, and the Collaboration Data Objects (CDO) Library. It demonstrates ways in which these technologies can be tied together into effective business solutions--from small-scale groupware to large-scale enterprise-wide systems. Developing Applications using Outlook 2000, CDO, Exchange, and Visual Basic offers an overview of the Microsoft collaborative landscape, and then examines each element of that environment in detail. Numerous examples showcase the applications made possible with these technologies and demonstrate VBScript coding techniques. You will find in-depth information on such important topics as: properties, methods, and events available in Outlook 97, 98, and 2000 the Outlook 2000 object model working with Outlook 2000 mail, calendar, task, and address book capabilities VBA and COM add-ins using Outlook Forms and VBScript Outlook web access the Forms 2.0 to HTML converter tool the CDO rendering object model Exchange agents and routing objects In addition, this book shows how a number of outside technologies can extend the capabilities of the Outlook/Exchange development environment, including Active Directory (ADSI) services, SQL Server, and ActiveX Data Objects (ADO). The examples include approving purchase order reports using Exchange, maintaining a corporate directory using Outlook and SQL Server, and building an eCommerce application with Exchange and SQL Server. A comprehensive supporting Web site, including sample code and Visual Basic project files, can be found at http://www.MMAnet.com/OutlookExchange. 0201615754B04062001

Understand how to take database needs and turn them into effective Access databases while gaining a thorough understanding of Access tables, forms, reports, and queries with this definitive handbook.

Exploit powerfully enhanced programmability in Office XP with authoritative information -- straight from the Microsoft Office development team. This hardcore programming reference comes packed with practical, roll-up-your-sleeves resources to help you maximize your productivity with development tools for Microsoft Office, including the Microsoft Visual Basic "RM" 6.0 and Microsoft Visual C++ "RM" development systems. This guide includes coverage of Workflow Solutions for Microsoft SQL Server "TM" and Microsoft Exchange, offering both design and coding examples, plus API-level coding examples. It also covers enhanced support in Microsoft Office XP for Web-enabled information sharing and XML. Use this incisive coverage to build on what you know and to accomplish everything from automating individual tasks to creating complex vertical-market applications. Each chapter presents dozens of code examples that illustrate the discussion. And the companion CD-ROM contains hundreds of procedures you can use right now -- helping you to focus your creativity on designing solutions, rather than on building rudimentary code. It's everything you need to create better business solutions, faster!