by on October 22, 2010 Leave a Comment

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

Filed Under: Excel, Microsoft, Office News, VBA Tagged With: , , , , , , , , , , , , ,
by on October 12, 2010 Leave a Comment

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

Filed Under: Excel, Microsoft, VBA Tagged With: , , , , , , , , , , ,
by on September 25, 2010 Leave a Comment

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

Filed Under: .NET, Access, Code, Excel, Microsoft, Office Development, SQL Server, VBA, VSTO, Word Tagged With: , , , , , , , , ,
by on September 13, 2010 Leave a Comment

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

Filed Under: .NET, Access, Code, Excel, Microsoft, OBA, Office 2010, Office Development, VSTO, Windows, Word Tagged With: , , , , , , , , , , ,
by on September 10, 2010 Leave a Comment

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)

Filed Under: .NET, Access, Articles, Code, Excel, Microsoft, Office Development, VBA, VSTO, Windows, Word Tagged With: , , , , , , , , , , ,
by on August 31, 2010 Leave a Comment

Retrieving Lists of Hidden Rows or Columns in Excel 2010 Workbooks by Using the Open XML SDK 2.0 (Visual How To)

Watch the video and explore code as you learn how to use Open XML file formats to retrieve information about hidden rows and columns in an Excel worksheet. Author: Ken Getz (MVP)

Read the original post:
Retrieving Lists of Hidden Rows or Columns in Excel 2010 Workbooks by Using the Open XML SDK 2.0 (Visual How To)

Filed Under: .NET, Code, Excel, Office Development, VSTO Tagged With: , , , , , , , , , ,
by on August 31, 2010 Leave a Comment

Video: Retrieving Lists of Hidden Rows or Columns in Excel 2010 Workbooks by Using the Open XML SDK 2.0

Watch this visual how-to video as you learn to use Open XML file formats to retrieve information about hidden rows and columns in an Excel worksheet. Author: Ken Getz (MVP)

Here is the original post: 
Video: Retrieving Lists of Hidden Rows or Columns in Excel 2010 Workbooks by Using the Open XML SDK 2.0

Filed Under: Code, Excel Tagged With: , , , , , , ,
by on August 31, 2010 Leave a Comment

Sample: Retrieving Lists of Hidden Rows or Columns in Excel 2010 Workbooks by Using the Open XML SDK 2.0

Explore the code in this visual how-to article as you learn to use Open XML file formats to retrieve information about hidden rows and columns in an Excel worksheet. Author: Ken Getz (MVP)

Here is the original: 
Sample: Retrieving Lists of Hidden Rows or Columns in Excel 2010 Workbooks by Using the Open XML SDK 2.0

Filed Under: Code, Excel Tagged With: , , , , , , , ,
by on August 19, 2010 Leave a Comment

Debugging Tips with Visual Studio 2010

This is the twenty-sixth in a series of blog posts I’m doing on the VS 2010 and .NET 4 release.

Read more: 
Debugging Tips with Visual Studio 2010

Filed Under: .NET, Code, Excel, Microsoft, VBA, Windows Tagged With: , , , , , , , , , , , , ,
by on August 10, 2010 Leave a Comment

Video: Retrieving the Values of Cells in Excel 2010 Workbooks 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 the value of a cell in an Excel 2007 or Excel 2010 document.

More: 
Video: Retrieving the Values of Cells in Excel 2010 Workbooks by Using the Open XML SDK 2.0

Filed Under: .NET, Excel, Office Development, VSTO Tagged With: , , , , , , , , ,
« Older Posts
Newer Posts »