Mailto Links in VBA
August 31, 2010 @ 7:00 AM by JP • No Comments
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.
Calculate Working Hours In Reverse
August 27, 2010 @ 7:00 AM by JP • 2 Comments
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?
Get Data Validation Range
August 24, 2010 @ 7:00 AM by JP • No Comments
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).
Documentation Best Practices for Web APIs
August 20, 2010 @ 7:00 AM by JP • No 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!
An exploration of IE browser methods, part III
August 17, 2010 @ 7:00 AM by JP • No Comments
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.
State Weather Advisories available by RSS
August 13, 2010 @ 7:00 AM by JP • No Comments
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.
-
Categories
- .NET (3)
- Access (18)
- AddIns (27)
- Administrative (47)
- Automation (35)
- Excel (158)
- Internet Explorer (7)
- Java (4)
- Off Topic (4)
- Office (11)
- Office Cafe (6)
- Outlook (81)
- Rant (13)
- Tutorial (10)
- VBA (113)
- Word (5)
Browse the Archives
-
Recent Posts
Latest Comments
-
About Code For Excel and Outlook
This site was created in November 2007 as a means to provide sample VBA code for programming projects. Currently there are- 367 blog posts,
- 131 pages,
- 1,429 comments,
- 17 categories,
- 624 tags, and
- Seven FREE Excel Add-Ins.
About the Author
I'm just an average guy who writes VBA code for a living. This is my personal blog. Excel and Outlook are my thing, with a sprinkle of Access and Word here and there. Follow this space if you want to learn more about VBA. Keep Reading » Stick around, buy an Excel book or browse the blogs I read.
-
Newsletter
If you'd like to receive occasional updates about the site, subscribe to my newsletter. -
From my bookshelf
Who's Online Now
RSS Feed
Get Articles by Email
View all subscription options »
