This is the Update tag.

Administrative icon

2013 State of the Blog


It has been a while since I last posted, so I thought I'd provide a short update on what has been happening lately with the site.

I haven't spent much time writing VBA. Between the holidays, family and work, there simply isn't time to sit down and write a proper blog post.

I did, however, launch a new website on New Year's Eve because I have been spending more time writing PHP. Click here if you want to check it out. So far I have two WordPress plugins and four MyBB plugins written, with one more of each pending.

2012 Stats

Last year this site had 250,000 visits from 200,000 people. After getting close to 2,000 hits per day, my site was spanked by Google's algorithm update, so now we get around 800. I didn't think I write like a robot but apparently Google thinks differently. I should probably order a website review to figure out what I'm doing wrong.

Most popular referrers

These sites provided the most visits in 2012:

Thank you to everyone who felt compelled to link to this site!


The mail merge tutorial continues to be the most popular download. Visit the Downloads page for a full listing.


Updates to ShipTrack and RDG are in progress. ShipTrack has become more popular and several new carriers have been added. A few more enhancements are pending.

I will continue to post to this blog as time permits. There are still a few more posts in the "Useful Array Functions for VBA" series that I have yet to complete.

Administrative icon

Updated website

I've enjoyed working with the Genesis framework for WordPress so much with my new site for Random Data Generator that I've decided to apply it to Code For Excel and Outlook as well. It has taken only a few hours but the conversion is almost complete.

I hope you enjoy the new look as I work to improve the site for your benefit. If you see anything odd please let me know (nobody ever does, but I thought I'd mention that anyway). No links will change, except as I mentioned in my previous post that all links to Random Data Generator will be referred to the new site.

AddIns iconAdministrative icon

More updates coming


New blog articles will be sporadic for the time being. I'm updating Random Data Generator to work with Excel 2007. I'm also writing an add-in for the World Bank Apps For Development Contest. So my time is going towards that instead of blog posts.

I'm also writing Excel 2007 versions of my other add-ins, and some new add-ins as well.

In the meantime, if you're bored, check out my new add-in for removing whitespace from worksheets: Clean And Trim.

Also, it's not too late to register for the New York and San Francisco Business of APIs Conferences.


Automation iconExcel iconOutlook icon

Update Outlook Task Reminder Dates from Excel

A few days ago I completed a routine that lets you update Outlook task reminder dates from Excel. For example, if you had a list of tasks in one column, with updated dates in a second column, this routine would allow you to change the reminder date for the task to the newly updated date. Works well if you are managing a project and need to change reminder dates for particular items.

Continue Reading »

Excel School