The goal of these exercises is to enable you to customize Microsoft Excel 2010 for your own applications. Each task addresses a particular scenario.
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.
New Excel Developer Roadmap 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
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 is a free application that allows discovering and importing data from Windows Azure Marketplace DataMarket into Microsoft Office Excel.
DataMarket Add-In for Excel (CTP1)
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.
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.
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
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
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.