Leveraging Windows Azure WCF Services to Connect BCS with SharePoint Online

Introduction You might have read an earlier post of mine where I discussed the new Business Connectivity Services (BCS) functionality in SharePoint Online (SP-O) and walked through how you can leverage jQuery and JavaScript to interact with an external list in SharePoint Online. This blog post assumed that you had created an external list in the first place and provided you with some code snippets to create a view of an external list. Since that time, a great post from Christian Glessner popped up that shows you how you can walk through creating an external list using SQL Azure.

See original here: 
Leveraging Windows Azure WCF Services to Connect BCS with SharePoint Online

Processing Documents in Bulk Using SharePoint 2010 and Open XML 2.0

Learn to use the Open XML SDK 2.0 to generate specific documents, SharePoint 2010 to store those documents, Word Automation Services to convert them to XPS files to print, and .NET Framework code to send them to the printer.

View original post here:
Processing Documents in Bulk Using SharePoint 2010 and Open XML 2.0

Sample: Processing Documents in Bulk Using SharePoint 2010 and Open XML 2.0

Explore code that uses the Open XML SDK 2.0, SharePoint 2010, Word Automation Services, and .NET Framework code to process documents in bulk.

Originally posted here:
Sample: Processing Documents in Bulk Using SharePoint 2010 and Open XML 2.0

Sample: Deleting Comments By All Authors or Specific Authors in Word 2010 Documents by Using the Open XML SDK 2.0

Explore this visual how-to sample as you learn to use strongly typed classes in the Open XML SDK 2.0 to delete comments by all or specific authors in a Word document.

Excerpt from:
Sample: Deleting Comments By All Authors or Specific Authors in Word 2010 Documents by Using the Open XML SDK 2.0

A New Center for Excel Developer on MSDN

I thought that I should notify readers of my blog that Microsoft recently has launched a new Excel Developer Center on MSDN.

The rest is here:
A New Center for Excel Developer on MSDN

Video: Retrieving the Table of Contents from Word 2010 Documents by Using the Open XML SDK 2.0

Watch this visual how-to video as you learn to use the strongly typed classes in the Open XML SDK 2.0 to retrieve an XML block that contains the table of contents from a Word document, without loading the document into Microsoft Word.

Go here to read the rest:
Video: Retrieving the Table of Contents from Word 2010 Documents by Using the Open XML SDK 2.0

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)