Prize Update

All the prize winners have been notified and the prizes have been mailed out. If you were notified as a winner and got back to us with your mailing address you should be receiving your prize any day now (if you haven’t already). If you sent us your info but haven’t received your prize by…


Solution – Exprienced Challenge 6: How Do You Spell That Again?

This was a challenge a good 15 or 20 years in the making. That’s not because it took us that long to come up with the challenge; even we work faster than that. It’s just that one of the OfficePalooza organizers learned about the Soundex algorithm 15 or 20 years ago (yes, back when he…


Solution – Experienced Challenge 5: I’m Leaving on a Jet Plane

We have to admit that Challenge 5 took us a little by surprise: it turned out to be easier than we anticipated. (As you might expect, things almost always turn out to be harder than we expect.) Even we knew that a simple SQL query could return a collection of all the non-stop flights from…


Day 5

OfficePalooza Day 5 is here! Challenges 3 and 4 were due today. Take a look at the solutions to those challenges that we came up with. We’re halfway through this two-week event, but we’re not halfway through the challenges yet. Two more are due first thing Monday morning.And guess what? Today we’re featuring Microsoft Office…


Solution – Novice Challenge 4: I Need a New Style

Our initial idea for this challenge was to have you set the font in the entire document to the first font on the local computer (alphabetically speaking) that begins with the letter B. However, we changed our minds about the alphabetically part; we’ll explain why when we take you through the solution we came up…


Solution – Novice Challenge 3: What Do I Owe You?

Challenge 3 was an interesting one. Not so much the challenge itself, but people seemed surprised at how little authors made in royalties. (This may come as a shock to some people, but most authors don’t make a lot of money off book sales.) Be that as it may, those are the numbers we came…


Solution – Experienced Challenge 4: Hmmm, So Maybe This is Rocket Science After All

This is the story of The Challenge That Almost Wasn’t. When we first thought of adding a missile trajectory challenge to OfficePalooza (because, after all, could you really call yourself a Palooza if you didn’t have missiles in there somewhere?) we immediately turned to the Internet for help on calculating such a trajectory. Note. Yes,…


Solution – Experienced Challenge 3: Are You Smarter Than a PowerPoint Developer?

What could be more fun than taking a test? OK, good point: pretty much everything is more fun than taking a test. Fortunately, in Challenge 3 you didn’t have to take the test, all you had to do was write the test. And writing a test is a whole bunch of fun. Uh, isn’t it?…


Day 4

It’s Day 4 of OfficePalooza! Two more challenges in each division are due tomorrow, Friday, April 24, by 8:00 AM PDT.   Head to the Home page to check your scores (we have a couple of ambitious people who’ve already earned 100 goldfish!) and view the challenges, and while you’re there check out Microsoft SharePoint…


Solution – Novice Challenge 2: What Did I See?

This challenge required that you use search and replace and that you know how to call up an input box. Neither of those things is too difficult once you find the right functions and objects. Here’s the solution we came up with: Sub ChangeSubject()   Dim strSubject As String Dim strReplace As String   ‘Set…