Create SQL Server Compact Edition Database with VBA

In a previously post I wrote about how we can retrieve data from a SQL Server Compact Edition (SSCE) database with ADO and Excel.

Here is the original post:
Create SQL Server Compact Edition Database with VBA

Video: Converting Word 2010 Documents from the DOCM to DOCX File Format by Using the Open XML SDK 2.0

Watch this visual how-to video as you learn to use strongly typed classes to convert Word 2010 documents from the DOCM to DOCX file format by using the Open XML SDK 2.0.

Original post: 
Video: Converting Word 2010 Documents from the DOCM to DOCX File Format by Using the Open XML SDK 2.0

Object Model Considerations for Protected View in Word 2010

I got some great questions recently about macros and Protected View in Word 2010, and thought I'd write something up to help anyone else who's looking at this issue – enjoy!   Word 2010 includes enhancements to security, one of which is the inclusion of a Protected View used when opening files from untrusted sources (e.g.

View original here:
Object Model Considerations for Protected View in Word 2010

Using Microsoft Word to Create Reports For LightSwitch (or Silverlight)

LightSwitch has a really nice feature on data grids that allow you to export them to Excel if running out of browser (full trust). This gives you a basic way of getting data out of the system to create reports or do further analysis on the data using Excel. However, in business applications you typically want to provide some client-side reporting that also formats the data in a certain way so it can be printed easily.

More:
Using Microsoft Word to Create Reports For LightSwitch (or Silverlight)

Video: Connecting to a WCF Service Using Business Connectivity Services in Office 2010

Watch this video as you learn to create a BCS external content type for Office 2010 based on a Windows Communication Foundation (WCF) service.

The rest is here:
Video: Connecting to a WCF Service Using Business Connectivity Services in Office 2010

Sample: Connecting to a WCF Service Using Business Connectivity Services in Office 2010

Explore the code as you learn how to create a BCS for Office 2010 based on a Windows Communication Foundation (WCF) service.

See the rest here:
Sample: Connecting to a WCF Service Using Business Connectivity Services in Office 2010

Sample: Deploying Multiple Office 2010 Projects in One Package

Explore the code in this visual how-to article as you learn to deploy an Office solution that uses ClickOnce deployment.

See more here:
Sample: Deploying Multiple Office 2010 Projects in One Package

Sample: Retargeting a Word 2007 Add-In that uses Smart Tags from .NET 3.5 to .NET 4.0

Explore the code in this visual how-to article as you learn to change the target version from .NET Framework 3.5 to .NET Framework 4.

View original post here: 
Sample: Retargeting a Word 2007 Add-In that uses Smart Tags from .NET 3.5 to .NET 4.0

Video: Setting a Custom Property in a Word 2010 Document by Using the Open XML SDK 2.0 for Microsoft Office

Watch this visual how-to video as you learn to use strongly typed classes to modify document properties in Word 2007 or Word 2010.

See the original post here:
Video: Setting a Custom Property in a Word 2010 Document by Using the Open XML SDK 2.0 for Microsoft Office

Accessing an OData Producer using an Office 2010 Add-in

To continue the theme of landing external data in Office 2010, I’ve taken a demo excerpt from a session I presented at a conference last week to show how easy it is to land OData information in an add-in. In this sample I simply use the Northwind Database which is a publicly available OData producer .

Original post:
Accessing an OData Producer using an Office 2010 Add-in