Mailto Links in VBA

August 31, 2010 @ 7:00 AM by JPNo Comments

mailto

On Jon Fournier's blog there's a VBA procedure to create a mailto: link in a macro. I like it but I feel it could use some more detail. I'll present an alternate with a few changes.

Continue reading this entry »

Excel

Calculate Working Hours In Reverse

August 27, 2010 @ 7:00 AM by JP2 Comments

clock

Problem: Every day I come in to work and intend to work eight hours. If I come in at 8:30 AM, and given an hour lunch, what time do I need to leave to work exactly eight hours?

Continue reading this entry »

Excel

Get Data Validation Range

August 24, 2010 @ 7:00 AM by JPNo Comments

valid

In Add Data Validation to any worksheet using VBA I demonstrated a technique for … adding data validation to any range. Surprise! ;-)

Now we'll try and do something with those data validation ranges. What I'd like to do is select a cell that has data validation on it and return the list of valid members (assuming that the source data is a Range or name that refers to a Range).

Continue reading this entry »

Documentation Best Practices for Web APIs

August 20, 2010 @ 7:00 AM by JPNo Comments

Programmable Web has a nice article called Web API Documentation Best Practices. It brings up several important points about how API developers should document their APIs. Consider this article a call to API developers — maintain your documentation!

Continue reading this entry »

Internet Explorer

An exploration of IE browser methods, part III

August 17, 2010 @ 7:00 AM by JPNo Comments

digital circuit

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 this entry »

State Weather Advisories available by RSS

August 13, 2010 @ 7:00 AM by JPNo Comments

weather

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 this entry »

Site last updated August 24, 2010 @ 5:56 pm