Generate invoice numbers in Excel

If you need a way to create invoices in Excel, you can use one of the many invoice templates on Office.com. While these templates are a great starting point, they don't automatically generate unique invoice numbers—you need a macro for that.

View post: 
Generate invoice numbers in Excel

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

Sample: Outlook 2010: Manipulate Items in Mail Conversations Using Outlook.Conversations

This sample shows how to use the new Conversation object in Outlook 2010 to manipulate items in a mail conversation.

Here is the original post:
Sample: Outlook 2010: Manipulate Items in Mail Conversations Using Outlook.Conversations

Sample: Outlook 2010: Access Lists of SharePoint Objects Using Outlook.PickerDialog

This sample shows how to use the new PickerDialog object in Outlook 2010, to access a SharePoint server to get a list of objects such as users, distribution lists, and so forth.

Read the rest here: 
Sample: Outlook 2010: Access Lists of SharePoint Objects Using Outlook.PickerDialog

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

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

Video: Getting Started with VBA Development in Office 2010

Watch this visual how-to video as you learn to extend Microsoft Office 2010 with VBA programming for non-programmers. Author: Peter Gruenbaum (Other)

Read the original post:
Video: Getting Started with VBA Development in Office 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)