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

Dealing with a SharePoint Security Breach

This week a friend of mine told me about a SharePoint related “incident” at his company where it was discovered that someone had posted a spreadsheet that contained sensitive employee data.   The file was not properly secured (discovered via a keyword search) and quickly was removed; no damage was done.   Nonetheless, it got me thinking about the appropriate steps to take during such a scenario… and, if you know me, that means having a plan.

More:
Dealing with a SharePoint Security Breach