Over at Automated Word Mail Merge I have a sample workbook for creating a mail merge in Excel using VBA, but I've felt the example wasn't the best. So I produced another, and here it is.
Continue Reading: Mail Merge in Word+Excel using VBA »
Link Excel cells to Outlook data fields
September 7, 2010 by · 
Have you ever wanted to link Excel data to Outlook contacts? Here is a simple event handler that links cells on your Excel worksheet to data fields in Outlook's address book.
Continue Reading: Link Excel cells to Outlook data fields »
An exploration of IE browser methods, part III
August 17, 2010 by · 
In previous articles I've written about how to extract information from webpages, and interact with them to navigate through a website.
This article won't strictly focus on IE, but on several collections available through the MSHTML Object Model.
Continue Reading: An exploration of IE browser methods, part III »
State Weather Advisories available by RSS
August 13, 2010 by · 
In Exploring the NOAA API I posted code for consuming the NOAA RSS feed for Atlantic storms.
I also posted weather-finding functions using the Geonames API, the WebserviceX.NET API and even a cheap formula for opening weather.com.
Continue Reading: State Weather Advisories available by RSS »
Finding Constant Values
February 10, 2010 by · Here's a problem: You're automating Outlook in your Excel code (or any Office program for that matter), and need to find the value for an Outlook constant because you know you can't use built-in Outlook constants in late-bound Excel VBA code. How do you usually do it? Do an Internet search for the number?
Continue Reading: Finding Constant Values »
Follow Me