Blogs

In Microsoft Word’s print dialog, there’s a textbox called Pages. In it, you can specify which pages you want to print by separating individual pages and page ranges by a comma. I have a small app wherein I enter a starting serial number and an ending serial number. The output is [...] Read More...

  This blog post is brought to you by Karen Cheng a Program Manager on the Excel team.     In today's post, we'll show you how the arcade game Tower Defense was created in an Excel spreadsheet (see a video of the game being played here ).  In this game, creeps move toward your castle. You must defend it by placing towers which shoot at the creeps. The more creeps you kill, the more money you get to buy and upgrade your towers. To play, you'll need - · To download the...

When you need to test an object’s property, there are times when you must also test that the object exits. E.g. If Not rControl Is Nothing Then     If IsEmpty(rControl.Offset(0, 1).Value) Then         rControl.Offset(0, 1).Resize(1, 7).Value = clsTimeSheet.TimeArray     Else         MsgBox "Operation Failed"     End If Else     MsgBox "Operation Failed" End If This [...] Read More...

We want to thank all of you who submitted entries for our Excel challenge. We had great entries that were well designed using Excel 2010 features, VBA and the user interface. Many of you are as passionate about Excel as we are and we thank you for your feedback. We extend our congratulations to the following winners: First Prize Winner : Andre L G Viol, United States Prize: Xbox 360 Elite Video Game Entertainment System and a copy of the Xbox 360 game: FIFA 2010 Description of the application : The...

The last couple of weeks have brought the release of tools (4 tools in 2 weeks!) to help IT Professionals expedite Office 2010 deployment. This posts highlights those four newly released tools and provides links to get started learning about using them. Respectively, these tools help you assess and plan for an Office 2010 deployment, assess potential Office application compatibility issues, and customize your Office 2010 deployment. 1. Microsoft Assessment & Planning Toolkit 5.0 (MAP) MAP is...

Yesterday, I was writing about how you can access worksheet functions in different ways. And I was going on and on about it to the point where I’m now recreating a slimmed down Excel Object Model in VBA. How did this topic get away from me so fast? Anyway, I set up the CCell [...] Read More...

Hasn’t it been a great class module week? It all started with Rob’s post about custom collection classes, or what I call parent classes. If I make a Person class, I want a People class. If I make an Invoice class, I want an Invoices class to hold all of them. Back in [...] Read More...

Introduction Recently I had a discussion with a local colleague and friend about using third-party developing tools. He prefers to not use any other tools than Excel and VS.NET. In that way he says he gets 100 % control of the developing process. One of my main targets is to reduce the overall time the [...] Read More...