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

Creating a TOC with Hyperlinks Programmatically

Today’s author is Dennis Wallentin, XL-Dennis, of http://xldennis.wordpress.com/ A few weeks ago we posted a code example for creating a table of contents for your workbook. Dennis offers another approach with this code sample for creating a TOC with hyperlinks

See the rest here: 
Creating a TOC with Hyperlinks Programmatically

Creating a Custom Popup Menu

Today’s author is Derek Mang, owner of Systems Solution Developers Inc. You can find more useful tips from Derek on his website: www.officevbasolutions.com .

More: 
Creating a Custom Popup Menu

Chart Object Model in Word & PowerPoint

Over the next three posts this blog will cover some of the charting changes that have been made in Office 2010, many of which are the direct result of customer feedback.   As part of the Office 2007 release we overhauled charting throughout Office; however an OM for Word and PowerPoint was not provided.

Read more:
Chart Object Model in Word & PowerPoint

The DisplayFormat OM

New features in conditional formatting extend to the object model as well. Excel has traditionally allowed users to access the formatting of their cells through the object model. For example, Users can use the interior class which lives off the range object to access the formatting of the cell.

Original post:
The DisplayFormat OM

Group numbers into custom ranges

I was looking at SQM data about file size last week and ran into an interesting question.

See the original post here: 
Group numbers into custom ranges

Case-Sensitive string comparisons

Today’s guest blogger is Michael Groh, co-author of the popular Access 2007 Bible . The VBA language is not, by default, case-sensitive. A statement such as   CBool("XYZ" = "xyz") will always return True

Read the original: 
Case-Sensitive string comparisons

Handling the SQL Server bigint data type in Access 2007 using ADO

Today’s guest blogger is Vinny Malanga. Vinny is the CTO of IMI Software, Inc. , which specializes in software development for the property management industry.

See the original post here:
Handling the SQL Server bigint data type in Access 2007 using ADO

Showing hidden controls during development

Today’s guest blogger is Access MVP Michael Groh. I often use hidden controls on Access forms and reports to hold intermediate values, temporary "flag" values, and the like. Because these controls are invisible at runtime, it's useful to set their colors to garish combinations (like red fore color over a yellow back color) so that, in design view, it's immediately apparent they're not meant to be viewed by users

More here:
Showing hidden controls during development

Roll-your-own “traffic light” icon set

Posted by Chris Downs, writer, Access IW Content Team Here’s a great tip suggested by Clint Covington.

Here is the original: 
Roll-your-own “traffic light” icon set