Quick Note: Creating an XML Mapping Schema in Excel 2010

Learn to create and utilize Xml Mapping schemas in Excel 2010.

Read the original post: 
Quick Note: Creating an XML Mapping Schema in Excel 2010

New Excel Developer Roadmap on MSDN

This blog post is brought to you by Allison Bokone a technical writer for Excel. With the wide variety of solutions available for automating, customizing, and extending Excel, it can be hard to determine which technology to use.

More here:
New Excel Developer Roadmap on MSDN

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

Sample: Creating and Publishing Excel 2010 Documents with Custom SharePoint 2010 Workflows

Explore the code as you learn to generate Excel spreadsheets inside SharePoint workflows and publish them to SharePoint sites.

Go here to see the original: 
Sample: Creating and Publishing Excel 2010 Documents with Custom SharePoint 2010 Workflows

DataMarket Add-In for Excel (CTP1)

DataMarket Add-In for Excel is a free application that allows discovering and importing data from Windows Azure Marketplace DataMarket into Microsoft Office Excel.

Read more: 
DataMarket Add-In for Excel (CTP1)

Pulling RSS data into Excel (or: Using Excel to Search Craigslist) – Part 2

This blog post is brought to you by Dan Battagin a Lead Program Manager on the Excel team. You’ll remember last time that we’d built a spreadsheet that searched Craigslist via the RSS feed that’s available for search results, and pulled the information into Excel using the little-used XML Map feature. Today, we’ll continue on where we left off, adding the ability to search multiple sites, and adding a little progress indicator in case the search takes a long time.

Read more:
Pulling RSS data into Excel (or: Using Excel to Search Craigslist) – Part 2

Pulling RSS data into Excel (or: Using Excel to Search Craigslist) – Part 1

This blog post is brought to you by Dan Battagin a Lead Program Manager on the Excel team. OK, so I’m going to talk a bit about a relatively unknown feature in Excel: XML data import. It was introduced in Excel 2003, but we’ve done a pretty good job hiding it since Excel 2007 by putting it on the Developer tab of the Ribbon.

Continued here:
Pulling RSS data into Excel (or: Using Excel to Search Craigslist) – Part 1

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

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)