Solution – Experienced Challenge 7: It’s Showtime!

This was an interesting challenge for us. We knew that there was no simple, straightforward way to implement a countdown timer in Microsoft Office PowerPoint. In addition, we assumed that there was a way to implement a countdown timer in Microsoft Office Excel; however, we weren’t positive that this could be done. So did we…


Solution – Novice Challenge 8: It’s Not My Fault

We all make mistakes, right? Like maybe we say something we really shouldn’t have said, or even worse, we write down something we really shouldn’t have written down. Or sometimes we say or write something down that’s perfectly okay, unless someone thinks a different person was responsible for saying it or writing it down. Or…


Solution – Novice Challenge 7: Switcheroo

This was an interesting challenge. As with just about any coding challenge, there were multiple ways of accomplishing this task. For the challenges so far we’ve seen code ranging three lines long to code 20 lines long, with the outcome of both being identical. We usually would never presume to tell anyone which way is…


Day 7

It’s Day 7, and guess what we have in store for today? Today is Office Communicator/Office Communications Server Day! Yes, that’s right, two products for one! But these two products are so closely tied together that it just makes sense to highlight them both. Spend a few minutes reading up on Office Communicator and Office…


Day 6

We’re  back for Week 2 of OfficePalooza! Challenges 5 and 6 were due this morning. Check our solutions and see how they compared to yours. We know, some of you might just be hearing about OfficePalooza, and here it is more than half over. (Even on the Internet sometimes word doesn’t spread as quickly as…


Solution – Novice Challenge 6: How Animated Am I?

For the first five challenges we sort of eased you into all the Visual Basic for Applications (VBA) stuff. This is, after all, the Novice division, so these challenges aren’t supposed to be too hard. But after easing beyond the halfway point, it was time to make things a little more, well, challenging, here in…


Solution – Novice Challenge 5: You Name It

We’ll start out by admitting something to you: we messed up. That probably isn’t a big surprise to anyone. What is a surprise (and a nice one at that) is that we messed up in a way that made things harder on us, but easier on you. (Okay, that really shouldn’t be a surprise either:…


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…