100th Post and a Code Contest
December 11, 2008 • JP • No Comments • Rate This Article
• Links to this article
In honor of my 100th blog post (which you are reading right now), I'd like to take a moment to recognize a few of my online friends and fellow bloggers who've made my experience more enjoyable, as well as provided valuable support and content for this blog's continued existence. I never thought I'd get this far and had no idea how big this would get when I started. This is not an exhaustive list; it would be far too long otherwise.
Enjoy the link love!
So far this year (Jan.1 to today), this site (including blog, but not counting feed) has received the following traffic:
- 49,400 visitors
- 60,300 visits
- 122k pageviews (average 2 pages per visit)
- 167 countries!
- 82% of visitors are first-timers
We're flirting with 500 feed subscribers, with the feed itself receiving several hundred hits per day. Traffic and readership has increased dramatically since the end of September, with the average number of visitors around 350 per day.
And of course the readers, commenters and visitors to this site deserve a HUGE thank you for your continued support!
Code Contest
To that end, I'm announcing a contest to highlight useful Excel and Outlook VBA code. Send me your favorite Excel or Outlook VBA code and explain what it does, how to use it, and why it's so useful to you. I'll post all of the entries here, and provide an email address for site visitors to vote on their favorite. The person who receives the most votes will receive my personal copy of "Accessing and Analyzing Data with Microsoft® Excel" by Paul Cornell, Microsoft Press.
The runner-up will receive my copy of "On Time! On Track! On Target!" by Bonnie Biafore, Microsoft Press.
Contest Rules
Email your entries to contest@codeforexcelandoutlook.com. Entries must be received by 12:00 AM EST on December 23rd, 2008. Entries remain the property of their respective owners. Limit two entries per person. Include your contact information (email & mailing address, and a link to your website or blog if available) when submitting your code. The code must be compiled and actually work. Entries will be tested for usability; I need to be able to drop the code into a module with Option Explicit and have it work properly the first time. Only submit code that you've written or adapted yourself, and are willing to share with others; your code will be checked for originality. If the code doesn't work or is clearly copied, or has proprietary information in it, I will send it back. Also, make sure you indicate version compatibility and international issues (if any) when submitting your code.
Please submit only one subroutine, unless your code requires multiple subs to work. For example, a main sub which does most of the work, with one or two "black box" functions that perform single-purpose calculations passed back to the main sub. Please do not submit entire workbooks, applications or add-ins, just subroutines or functions in txt format or pasted into the body of the email. Your contact info is only used to communicate with you about the contest, and mail you the prize (if applicable). All contact info is destroyed at the conclusion of the contest.
I will post all the entries after December 23rd and provide an email address for site visitors to vote. Voting will close approxmately one week after that post.
– end –
In other news, I've added some new feeds to each post. You can subscribe to the comments feed for a particular post by following the link "Subscribe to Comments" at the bottom of the post. So now there are three types of feeds you can subscribe to:
- The posts feed (all blog posts)
- The comments feed (all comments regardless of post)
- The comments feed for a particular post
You can also follow post comments by filling out the "Subscribe without commenting" textbox at the bottom of the comment box for a particular post. You'll receive an email whenever someone comments on that post.
I'd also like to mention there's an Excel user conference going on in London next year. There's an informative post about the EUC on Nick Hodge's blog.
(No Ratings Yet)
Loading ...What now?
Subscribe To The Blog
Email This Article
Follow Me On Twitter
My Facebook Page
Or just keep reading:
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 »
Previous Post: My guitar rig drawn in Excel
Next Post: SearchBox Week, Day 1
JP, congratulations on your 100th post! And thanks for the link love.
Debra
Thanks so much Debra, you deserve it
JP… this is such good news. I really enjoy your vba posts and it is not easy to cross the 100 milestone. Congratulations.
Thank you Chandoo for your continued support!
I've posted so many of my favorite code snippets on my website and blog that it's hard to find something new. Also, many of my later pieces are more advanced, and require a dialog (user form) in conjunction with a number of supporting routines.
But here's a very short and very useful procedure, which opens a Windows Explorer instance to the path of the active workbook. The "/e" parameter applies the Folders option to the left hand pane of the window.
If Len(ActiveWorkbook.Path) > 0 Then
Shell "explorer.exe /e ," & ActiveWorkbook.Path, vbNormalFocus
End If
End Sub
Man, you have your instructions for showing VBA code twice, and I still didn't follow them.
By the way, don't enter my routine in the contest. Since you listed me in the main post, I'd feel like a poacher.
Ugh, my comments.php file was edited incorrectly, so that message was printed twice. Fixed. Thanks
Hi JP,
Well done on the Ton,
Heres to the next 100 too!
Happy Xmas BTW!!
Cheers
Ross
Thanks Ross, same to you! Happy holidays.
I fear my own 'favourite' modules are far too simplistic (not to mention ultra-specific to my needs) to be worth extended scrutiny but I'm really interested to see what gems your contest throws up.