Jeff Webb - Böcker

Why program Excel? For solving complex calculations and presenting results, Excel is amazingly complete with every imaginable feature already in place. But programming Excel isn't about adding new features as much as it's about combining existing features to solve particular problems. With a few modifications, you can transform Excel into a task-specific piece of software that will quickly and precisely serve your needs. In other words, Excel is an ideal platform for probably millions of small spreadsheet-based software solutions. The best part is, you can program Excel with no additional tools. A variant of the Visual Basic programming language, VB for Applications (VBA) is built into Excel to facilitate its use as a platform. With VBA, you can create macros and templates, manipulate user interface features such as menus and toolbars, and work with custom user forms or dialog boxes. VBA is relatively easy to use, but if you've never programmed before, Programming Excel with VBA and .NET is a great way to learn a lot very quickly. If you're an experienced Excel user or a Visual Basic programmer, you'll pick up a lot of valuable new tricks. Developers looking forward to .NET development will also find discussion of how the Excel object model works with .NET tools, including Visual Studio Tools for Office (VSTO). This book teaches you how to use Excel VBA by explaining concepts clearly and concisely in plain English, and provides plenty of downloadable samples so you can learn by doing. You'll be exposed to a wide range of tasks most commonly performed with Excel, arranged into chapters according to subject, with those subjects corresponding to one or more Excel objects. With both the samples and important reference information for each object included right in the chapters, instead of tucked away in separate sections, Programming Excel with VBA and .NET covers the entire Excel object library. For those just starting out, it also lays down the basic rules common to all programming languages. With this single-source reference and how-to guide, you'll learn to use the complete range of Excel programming tasks to solve problems, no matter what you're experience level.

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.

Any situation where people need to work together online is a situation for Microsoft SharePoint. SharePoint is a component of Windows 2003 that enables organizations to construct web sites specifically for information sharing and collaboration. Within these sites, individuals can capture and share ideas, plus work together on documents, tasks, contacts, and events. "The SharePoint Office Pocket Guide" from O'Reilly gets you collaborating with others in this format immediately. It covers the ins and outs of SharePoint's key tools in plain, easy-to-follow language. Within minutes, you'll understand how to: determine which web site template is best for you; customize the design and content of the site's various pages; upload documents for all team members to see; add public announcements; send alerts to team members so they know when existing documents have been changed; add links to other external sites; track work items; call meetings from within Office 2003; and add new members to the site. Thanks to SharePoint, you'll discover that emailing is no longer the most efficient way to share files.In fact, you may never need to zip files together again, which also means an end to files that bounce back because they're too large. SharePoint renders all of this aggravation obsolete. If you want more information than the average SharePoint user, then the "SharePoint Office Pocket Guide" is an essential addition to your personal library. By increasing your team's productivity, SharePoint takes the "dead" out of deadline. And this handy reference guide shows you how to get it done.

If you're considering the vastly improved 2007 version of SharePoint, this concise, practical and friendly guide will teach you how to get the most from the latest version of Microsoft's information-sharing and collaboration platform. Essential SharePoint 2007 demonstrates how your business can use SharePoint to control documents, structure workflow, and share information over the Web using standard tools business users already know -- Microsoft Office and Internet Explorer. Written in a conversational tone by internationally recognized SharePoint consultant and trainer Jeff Webb, this book helps SharePoint administrators, site owners, and power users quickly gain the skills necessary to perform a wide variety of tasks for intranet and extranet web sites, and explains what's new in SharePoint 2007 for experienced SharePoint 2003 administrators.Essential SharePoint 2007 teaches you how to: * Use SharePoint 2007 with Outlook, Word and Excel, and as a document management tool, replacing, for example, shared network drives with libraries * Build and customize sites, lists, libraries and web parts for intranets and extranets * Use SharePoint 2007 for team communication through blogs, wikis, surveys, and RSS and email alerts * Build a SharePoint workflow application * Create and program web parts in order to deliver custom services and data to a site * Deploy and administer SharePoint 2007 Each chapter ends with a summary of best practices advocated by the author, and the first few chapters of the book are ideal as training materials for end users. Later chapters give developers and administrators tools not only to keep company sites running smoothly, but also to customize and extend them. The book also contains several appendices with a glossary of terms and hard-to-find information. Essential SharePoint 2007 is a one-stop task-oriented guide for learning what's necessary to make this tool a vital part of team productivity.

Similar to the CBC and BBC, the Broadcasting Corporation of Newfoundland was a public broadcaster that was at the centre of a cultural and political change from 1939 to 1949, during which Newfoundland faced wartime challenges and engaged in a constitutional debate about whether to become integrated into Canada. The Voice of Newfoundland studies these changes by taking a close look at the Broadcasting Corporation of Newfoundland's radio programming and the responses of their listeners.Making excellent use of program recordings, scripts, and letters from listeners, as well as government and corporate archives, Jeff A. Webb examines several innovative programs that responded to the challenges of the Great Depression and Second World War. Webb explores the roles that radio played in society and culture during a vibrant and pivotal time in Newfoundland's history, and demonstrates how the broadcaster's decision to air political debates was pivotal in Newfoundlanders's decision to join Canada and to become part of North American consumer society.An engaging study rich in details of some of twentieth-century Newfoundland's most fascinating figures, The Voice of Newfoundland is a remarkable history of its politics and culture and an important analysis of the influence of the media and the participation of listeners.

Similar to the CBC and BBC, the Broadcasting Corporation of Newfoundland was a public broadcaster that was at the centre of a cultural and political change from 1939 to 1949, during which Newfoundland faced wartime challenges and engaged in a constitutional debate about whether to become integrated into Canada. The Voice of Newfoundland studies these changes by taking a close look at the Broadcasting Corporation of Newfoundland's radio programming and the responses of their listeners.Making excellent use of program recordings, scripts, and letters from listeners, as well as government and corporate archives, Jeff A. Webb examines several innovative programs that responded to the challenges of the Great Depression and Second World War. Webb explores the roles that radio played in society and culture during a vibrant and pivotal time in Newfoundland's history, and demonstrates how the broadcaster's decision to air political debates was pivotal in Newfoundlanders's decision to join Canada and to become part of North American consumer society.An engaging study rich in details of some of twentieth-century Newfoundland's most fascinating figures, The Voice of Newfoundland is a remarkable history of its politics and culture and an important analysis of the influence of the media and the participation of listeners.

The years after Newfoundland’s confederation with Canada were ones of rapid social and economic change, as provincial resettlement and industrialization initiatives attempted to transform the lives of rural Newfoundlanders. At Memorial University in St. John’s, a new generation of faculty saw the province’s transformation as a critical moment. Some hoped to solve the challenges of modernization through their rural research. Others hoped to document the island’s “traditional” culture before it disappeared. Between them they created the field of “Newfoundland studies.”In Observing the Outports, Jeff A. Webb illustrates how interdisciplinary collaborations among scholars of lexicography, history, folklore, anthropology, sociology, and geography laid the foundation of our understanding of Newfoundland society in an era of modernization. His extensive archival research and oral history interviews illuminate how scholars at Memorial University created an intellectual movement that paralleled the province’s cultural revival.

In 1949, Newfoundland and Labrador had a widely celebrated oral culture but little visual art. After entering the Canadian federation, recreational painters worked to create a venue for the display of art. The Cause of Art tells the story of the advocates, curators, and professional artists who laid the foundation for an artistic community in the province.The Memorial University Art Gallery was the site of a struggle between recreational painters who aspired to express their creative impulse and develop a Newfoundland art, and curators who wanted artists to participate in the Canadian art market and international artistic movements. The book recounts the history of passionate and strong-willed curators and cultural administrators who fought for control of the gallery. It reveals how they appealed to competing conceptions of professionalization, as well as diverse political and aesthetic preferences.Based on extensive archival research in previously unexamined collections, and oral interviews with key informants, this book examines a cultural institution that is widely remembered as the centre of the cultural renaissance in late twentieth-century Newfoundland and Labrador. As a result, The Cause of Art illuminates the relationship between the state and the university during a key period in the modernization of the province.

In 1949, Newfoundland and Labrador had a widely celebrated oral culture but little visual art. After entering the Canadian federation, recreational painters worked to create a venue for the display of art. The Cause of Art tells the story of the advocates, curators, and professional artists who laid the foundation for an artistic community in the province.The Memorial University Art Gallery was the site of a struggle between recreational painters who aspired to express their creative impulse and develop a Newfoundland art, and curators who wanted artists to participate in the Canadian art market and international artistic movements. The book recounts the history of passionate and strong-willed curators and cultural administrators who fought for control of the gallery. It reveals how they appealed to competing conceptions of professionalization, as well as diverse political and aesthetic preferences.Based on extensive archival research in previously unexamined collections, and oral interviews with key informants, this book examines a cultural institution that is widely remembered as the centre of the cultural renaissance in late twentieth-century Newfoundland and Labrador. As a result, The Cause of Art illuminates the relationship between the state and the university during a key period in the modernization of the province.

Scotland's Lost Clubs: Giving the Names You've Heard the Story They Own is the gripping, constantly surprising, intrinsically romantic and all too commonly tragic story of some of Scotland's lost football clubs. You'll be taken on a journey across Scotland, from the Highlands to the English border, with tales of some of the most important names in world football and their impact on the modern game. Learn about the picturesque Victorian seaside town that had no fewer than five clubs, and the team that rescued a league rival who was shipwrecked only to sadly disappear the year Celtic won the European Cup. Discover how a mining village of less than 3,000 inhabitants became world champions but folded 36 years later. Football at its most raw and disorganised was a breeding ground for amazing stories, and Scotland's Lost Clubs captures some of the very best of them. It's essential reading for any Scottish football fan.