This is the Administrative category.

Administrative posts include contest announcements, technical notes about the site itself, and anything not directly Office-related.

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

Code For Excel and Outlook is now JP Software Technologies


I've changed the domain to be more in line with my expanding business. I'm afraid using trademarked terms in the URL was no longer tenable (no I did not receive a C&D).

If you are linking to Code For Excel and Outlook on your blogroll — thank you! Now go and please update your links. All you need to do is replace "" with "". The old links will continue to redirect for the life of the URL, however.

Continue Reading »

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.

Peltier Tech Charting Utilities for Excel