in the office - Channel 9

Office Live Tour for Developers: NorthwindInn.com

doncho — Fri, 25 May 2007 22:06:00 GMT

Web Developers: Watch this 20 minute screencast to see the exciting ways you can customize and extend Office Live. In this screencast, Rohit Puri takes you on a tour of NorthwindInn.com, an Office Live site based on a Bed and Breakfast business.

He will show you the three main ways that developers can customize and extend Office Live:

1) Customizing Business Applications including Lists, Libraries and Dashboards

2) Creating Web mash-ups in Office Live

3) Buidling Client Applications that communicate with Office Live via Web Services.

Specifically, the screen cast covers:
- Customizing the public site
- Customizing the private site
- Sharing data between the public and private sites
- Creating workflows and business logic
- Integrating with Office applications
- Integrating with rich client applications

All of the code and documentation for this will be available on MSDN shortly too, and I'll post the link in the comments when it is ready!

Extend your VBA with .NET!

doncho — Wed, 09 May 2007 18:02:27 GMT

Visual Studio "Orcas" makes it very easy for your existing VBA solutions to call Visual Studio Tools for Office (VSTO) methods!

By setting the "EnableVbaCallers" and "ReferenceAssemblyFromVbaProject" project properties to TRUE, VSTO automatically adds the necessary code spit and references to your VBA project.

Then you're free to mix managed .NET code with VBA script! Preserve your investment in VBA and amaze your friends as you effortlessly call VSTO using VBA's IntelliSense.

Join Eric Schnepp, Principal Program Manager in the VSTO team in this screencast to see how it all works.

Length: 8:08

Real-World Open XML and Ribbon Customization: Using Microsoft Office Word 2007 to Modify Mindjet Min

doncho — Fri, 09 Feb 2007 23:49:47 GMT

Description: Join Don Campbell, Technical Evangelist for Microsoft, and Michael Scherotter, Solutions Platform Evangelist for Mindjet, to see a demonstration solution from the Mindjet Labs that uses the Open XML file format of Microsoft Office Word 2007 to transform business data from MindManager to Word 2007 and back again.

This technical demonstration shows how high-fidelity round-trip scenarios are possible with the Open XML file formats when used in conjunction with other XML-based applications, like Mindjet MindManager.

In the export to the Open XML file format, this solution creates a custom Ribbon UI tab embedded in the document. This allows the Word 2007 user to take advantage of some of the visual organization and project planning capabilities of MindManager while using Microsoft Word 2007.

This also highlights the MindManager Solution Platform which makes such integrations easy, quick, and visual.

Time: 38:26

Use data sharing to connect your public and private Office Live web sites

doncho — Fri, 05 Jan 2007 00:59:58 GMT

Chris Beiter, Developer Platform PM for Office Live, shows how to use Data Sharing to connect your public Office Live web site to your secure private Office Live site.

Data Sharing allows you to automate collection or publishing of data from and to your web site. Once the data is in a list, you can use workflow, views, and Office client integration.

In the screencast, you'll see how to use the data capture web part to capture "leads" from the public web site and update a new Web Leads area in the Business Contact Manager (BCM). This triggers a workflow to e-mail to a business manager to qualify it. This person can then initiate another workflow to move the lead to the BCM contacts list.

Related Links:

Duration: 26:59

Office Live Workflows

doncho — Sat, 02 Dec 2006 01:24:57 GMT

In this Office Live screencast, Albert Shen shows you how to add Workflows to Office Live Business Applications using SharePoint Designer 2007 .

Office Live is built on Windows SharePoint Services v3 and as a result, leverages the powerful new Related Links:

Video length: 14:12

Using the Data Form Web Part in Office Live

doncho — Sat, 02 Dec 2006 00:40:42 GMT

In this Office Live screencast, Albert Shen shows you how to use SharePoint Designer 2007 to build powerful views of your business data, and integrate them into your Office Live Business Applications.

The Data form web part can consume data from various data sources including SharePoint lists, SharePoint libraries, server side scripts, RSS feeds, XML files, databases, web services, or an aggregation of these sources.

Using ASP.NET 2.0 data source controls, the data form web part retrieves data as an XML document, and then uses XSLT to transform the data for the browser.

Related Links:

Video length: 17:16

Office Live with SharePoint Designer

doncho — Fri, 01 Dec 2006 23:33:47 GMT

SharePoint Designer 2007 is a great tool for designing, developing and customizing your Business Applications in Office Live.

In this screencast Albert Shen, a software design engineer on the Office Live team, will show you the various capabilities in SharePoint Designer and how you can use them with Office Live.

He covers:

Site Management Tools
   Files, lists, workflows, Master pages
   Moving folders
   Adding and removing files from the site

Creating new file content
   HTML, ASPX, CSS, Master Pages, DWT, JavaScript, Text
   SharePoint Content like lists, libraries, surveys and workflows
   Create new pages from scratch using included CSS layouts

Page Editing
   Design, split, and code views
   Quick tag editor
   CSS property grid
   Navigating through CSS containers
   ASP.NET Master Pages support
   Accessiblity and standards compliance checker

Related Links:

Video Length: 13:36

Opening & Saving Word, PowerPoint and Excel 2007’s new default file formats in previous versions

doncho — Thu, 19 Oct 2006 23:05:18 GMT

In this screencast, Word program manager Jonathan Bailor demonstrates how Microsoft Office 2003 users can open and save Word 2007’s new default XML based formats natively.

Jonathan Bailor’s Compatibility Pack post

Microsoft Office Word team blog
Brian Jones' OpenXML Formats blog
OpenXMLDeveloper.org

MSDN Word Developer Portal
MSDN XML in Office Developer Portal

Compatibility in Word 2007

doncho — Sat, 14 Oct 2006 00:55:16 GMT

In this screencast, Word program manager Zeyad Rajabi gives an introduction to “Compatibility Mode”. Compatibility Mode ensures that documents created from older versions of Word will look the same in Word 2007 and that documents created in Word 2007 will look exactly the same when opened by legacy word users.

Related Links:

Zeyad Rajabi’s Compatibility Mode post

Microsoft Office Word team blog
Brian Jones' OpenXML Formats blog

MSDN Word Developer Portal
MSDN XML in Office Developer Portal

Word, Excel, and PowerPoint’s New ‘Theme’

doncho — Sat, 14 Oct 2006 00:51:07 GMT

In this screencast, Word program manager Jonathan Bailor shows how to take advantage of the Theme feature new to Word, Excel, and PowerPoint 2007 when reusing content (“copying & pasting”).

Themes are one of the most useful features new to Word, Excel, and PowerPoint 2007. Put simply, a document Theme is a set of fonts, colors, and graphic/chart effects that are complementary and applied globally to documents, spreadsheets, and presentations. This screencast demonstrates how a Word document’s Theme is automatically applied to “pasted” content. Translation: you can reuse content from PowerPoint and Excel in Word, and vice versa, without having to reformat everything. A chart copied from an Excel spreadsheet with Theme X applied, will take on Theme Y when pasted into a Word document that has Theme Y applied to it. Put simply, pasted content 'fits in' with the rest of the document.

Related Links:
Jonathan Bailor’s Theming post
Microsoft Office Word team blog
Brian Jones' OpenXML Formats blog

MSDN Word Developer Portal
MSDN XML in Office Developer Portal

Opening & Saving Word, PowerPoint and Excel 2007’s new default file formats in previous versions

doncho — Sat, 14 Oct 2006 00:45:44 GMT

In this screencast, Word program manager Jonathan Bailor demonstrates how Microsoft Office 2003 users can open and save Word 2007’s new default XML based formats natively.

Jonathan Bailor’s Compatibility Pack post

Microsoft Office Word team blog
Brian Jones' OpenXML Formats blog
OpenXMLDeveloper.org

MSDN Word Developer Portal
MSDN XML in Office Developer Portal

Dynamic Word Documents

doncho — Sat, 14 Oct 2006 00:38:41 GMT

In this screencast, Office program manager Brian Jones shows how to use a custom schema to import data from Excel 2007 into a Word 2007 document.

Microsoft has adopted the Office Open XML file format, as the new default file format for Word, Excel, and PowerPoint 2007 to reduce file size, improve reliability, guarantee long term accessibility for archiving, and enhance interoperability with business solutions. A key piece of the integrating the contents of Office documents with business data is the ability to structure those documents semantically.

Word 2007 builds on top of the custom defined schema support introduced in Word 2003 and offers an extremely robust way to structure the contents of a document. In addition to allowing the solution builder to structure a Word template, they can then map those structures to their own custom XML schemas which allows the developers to program directly against the data rather than against the application’s object model. This allows for much simpler and more reliable solutions than in the past, and even allows the valuable contents within the documents to maintain a direct mapping to business data without writing any code. As Brian shows in this demo, that includes business data that exists within an Excel Spreadsheet.

Related Links:
Microsoft Office Word team blog
Brian Jones' OpenXML Formats blog

OpenXMLDeveloper.org

MSDN Word Developer Portal
MSDN XML in Office Developer Portal

Data/View Separation in Word 2007

doncho — Tue, 10 Oct 2006 23:32:24 GMT

In this screencast, Office program manager Brian Jones shows how to use content controls, data binding, and the custom XML data store to push/pull data to/from a Word 2007 document.

Microsoft has adopted the Office Open XML file format, as the new default file format for Word, Excel, and PowerPoint 2007 to reduce file size, improve reliability, guarantee long term accessibility for archiving, and enhance interoperability with business solutions.

A key piece of the integrating the contents of Office documents with business data is the ability to structure those documents semantically. Word 2007 builds on top of the custom defined schema support introduced in Word 2003 and offers an extremely robust way to structure the contents of a document.

In addition to allowing the solution builder to structure a Word template, they can then map those structures to their own custom XML schemas which allows the developers to program directly against the data rather than against the application’s object model. This allows for much simpler and more reliable solutions than in the past, and even allows the valuable contents within the documents to maintain a direct mapping to business data without writing any code.

Better Looking Documents in Minutes with Word 2007

doncho — Thu, 05 Oct 2006 17:17:51 GMT

In this screencast, Word program manager Jonathan Bailor shows how to how to create a professional looking document in less than five minutes using Live Preview, Theming, Quick Styles, Document Parts, and more, in Word 2007

ClearContext IMS Pro for Outlook 2007 - Alpha Demo

doncho — Thu, 07 Sep 2006 01:00:44 GMT

Deva and Brad from ClearContext stopped by to show me what they've been up to - a version ClearContext IMS Pro for Outlook 2007! This is shown on Office 2007 Beta 2. They are also looking for beta testers - so if you are running the Beta of Office be sure to check this out!

Creating WSS 3.0 Workflows with Visual Studio 2005

AdamKinney — Mon, 28 Aug 2006 20:40:03 GMT

Create a custom workflow with Visual Studio 2005 and configure it to run from within a WSS 3.0 site.

Anonymous Access and Forms Authentication with WSS 3.0

doncho — Sat, 26 Aug 2006 01:19:11 GMT

Learn how to configure a Windows SharePoint Services 3.0 site to use the ASP.NET 2.0 Forms Authentication Provider.

Web Content Management in MOSS 2007

doncho — Sat, 26 Aug 2006 01:09:17 GMT

Use the Web Content Management features of Microsoft Office SharePoint Server 2007 to create a custom page layout for publishing content to the web.

Creating Browser Enabled Forms With InfoPath 2007

doncho — Sat, 26 Aug 2006 01:04:42 GMT

Create and publish browser-enabled forms with InfoPath 2007 and Forms Services in Office SharePoint Server 2007.

Accessing Server-side Workbooks and Excel Services through Web Services

doncho — Fri, 04 Aug 2006 03:06:21 GMT

Program standard Web Services from a Windows Forms Application to load Excel workbooks and perform server-side calculations.

Configuring Security and Authorization with Windows SharePoint Services 3.0

doncho — Fri, 04 Aug 2006 03:02:13 GMT

Learn the new WSS 3.0 model for configuring access to a WSS site collection.

Retrieving Data Programmatically from the MOSS Business Data Catalog

doncho — Fri, 04 Aug 2006 02:56:27 GMT

Create a custom Web Part that performs custom queries against Microsoft Office SharePoint Server (MOSS) Business Data Catalog applications.

Introducing the Business Data Catalog (BDC)

doncho — Sat, 29 Jul 2006 00:06:00 GMT

In this screencast we show you how to access back-end systems using the Microsoft Office SharePoint Server (MOSS) Business Data Catalog.

Creating Windows SharePoint Services Sites with Support for Wikis and Blogs

doncho — Wed, 12 Jul 2006 00:35:07 GMT

Leverage the new built-in WSS features for creating sites with blogs and wikis.

Using Microsoft Office SharePoint Server to Create BI Dashboards and KPIs

doncho — Wed, 12 Jul 2006 00:27:00 GMT

Create a custom Report Center site with a MOSS dashboard using Key Performance Indicators (KPIs).