An extraordinary new feature in Microsoft Excel 5 called Visual Basic for Applications (VBA) makes it easy for anyone with an understanding of VBA to build powerful business solutions with the Microsoft Excel engine. This insider's guide introduces VBA and Microsoft Excel 5 as a full-fledged development environment and shows the best methods for building quality data access and decison-making tools.
Written by Microsoft’s own consulting team, this is the premier example-driven book for developing Office-based applications using SharePoint and .NET. It takes a practical problem/solution approach to common business challenges. You'll not only encounter interesting code samples, but also see how to combine these examples with the Microsoft collaboration platform's services. The book's solutions focus on using Visual Studio Tools for Office to build the user interface layer. In addition, solutions can interact with SharePoint as a service provider, taking advantage of SharePoint's many collaboration features.
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 manual has been specifically designed to help you produce a sample portfolio of evidence for CLAIT Advanced Unit 1. The step by step exercise based approach gradually progresses a problematic project to a successful solution. Useful data files are supplied with the manual which allow you to practise the different software features. Endorsed by OCR.
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.
Features end-to-end scenarios for using Office 2007 and SharePoint 2007, from generating Office documents programmatically to integrating document-based workflows with line of business applications or Web sites Takes an in-depth look at integrating the information worker products from Microsoft into broader solutions for the enterprise Some of the topics covered include building a workflow solution with Office and SharePoint 2007; programming SharePoint lists, items, and libraries; building Business Intelligence (BI) including Excel BI, Excel and Access Reporting, and SharePoint integration; using Web Content Management with SharePoint; and more
This book takes a practical problem-solution approach to common business challenges. You’ll not only encounter interesting code samples, but also see how to combine these examples with the Microsoft collaboration platform’s services. The book’s solutions focus on using Visual Studio 2008 and its built-in Office development tools to construct the user interface layer. And solutions can interact with SharePoint as a service provider, taking advantage of SharePoint’s many collaboration features like document repositories, collaboration sites, and search functions. This book is unique because it starts with challenges that end users deal with every day when using the Microsoft collaboration platform to support business processes. The solutions are presented as hypothetical business challenges of a fictional company. By presenting the examples in this context, author Ed Hild makes it easier to relate to the challenges and solution value. The goal of these examples is to build applications that apply the benefits of the Office desktop interface to the richness of SharePoint collaboration features. This book will help you develop real-world solutions to complex business problems and challenges.
The voice of the customer has long been recognized as an important driver for successful businesses. Likewise, there is a great deal of information on the benefits of quality function deployment and how it can revitalize an organization. But little has been written that connects the two together effectively to create a full understanding and show a process for effectively integrating the two disciplines. This is the focus of Developing New Services: Incorporating the Voice of the Customer into Strategic Service Development, which explains how to incorporate the voice of the customer into product and service development and uses the results to guide strategic planning for the organization. The book focuses on the service industries, providing expert examples from a variety of businesses such as healthcare, government, banking, education, and the hospitality industries. The authors’ experience as seasoned consultants and instructors is evident in the many real-world examples, exercises, and figures. Developing New Services is ideal for managers who are responsible for developing and improving services, and is also an ideal textbook for management students.
