A review of Add-in Express

A while ago I started transitioning from VBA to VB.NET again, attempting to build a tool to manipulate the new Power Pivot components in Excel 2013. While I was able to get part way to a working solution using Visual Studio 2012 and VSTO, I ran into two key issues:

1. VSTO seems to be “bit” specific, meaning that I would need to keep one version of the solution for 32 bit versions of Office, and another for 64 bit versions, and

2. While I could run my code, the Power Pivot engine would crash on me unless I opened Power Pivot BEFORE I ran any of my code.

Both of these issues were rather severe to me, as I didn’t want to maintain multiple versions of the same code, nor could I release something and expect users to open Power Pivot before running my project. A friend of mine suggested I try Add-in Express to deal with these issues.

In the spirit of full disclosure, I contacted them and asked if they had a trial version. They don’t, but offered to let me trial it if I’d blog on my experiences. I agreed to do that, and what follows is my honest observations of the software.

I do want to preface that, like my friend Rob Collie, I am not a “Read the manual” kind of guy. Ironic, since I write a lot of material, but I take the approach of diving in, and hitting Bing for a quick pointer when I get stuck. It usually causes me a lot of pain, but I tend to learn better that way.

So, here’s how it all came together for me…

When you install Add-in Express, you get a new set of templates. I started my project by creating a new ADX COM Add-in targeting the .NET Framework 2.0. (For those not in the know, in order to target Excel 2010 with VSTO, you need to use .NET 4.0 and Excel 2013 is .NET 4.5. So .NET 2.0 is way too early a framework to have ever even heard of Power Pivot!)


From there you pretty much follow the prompts through the setup. I called it “Connect”, I set the minimum supported version to Office 2010 (since PowerPivot didn’t exist in 2007), I chose a Visual Basic Project, I selected Excel, and I left the rest of the settings at their defaults. Pretty easy, that part.

Once I had a project to work with, I created a new VB Module, just like normal, and built the code I would need to refresh my PowerPivot model and all the PivotTables. (Be aware that, for simplicity of the post, this is 2013 specific code, and will not work with Excel 2010.)

The key piece in this is making sure the xlApp declaration is correct, as you need to refer to the AddinModule portion in order to bind it to Add-in Express’s handlers, instead of just binding to the Interop.Excel objects. That change is what makes Add-in Express work:

  1. Imports Excel = Microsoft.Office.Interop.Excel
  3. Module Module1
  5. Public xlApp = Connect.AddinModule.CurrentInstance.ExcelApp
  7. Public Sub RefreshPowerPivotTables()
  9. Dim xlWorkbook As Excel.Workbook = xlApp.ActiveWorkbook
  11. Dim ws As Excel.Worksheet
  13. Dim pvt As Excel.PivotTable
  15. 'Attempt to connect
  17. Try
  19. xlWorkbook.Connections("ThisWorkbookDataModel").Refresh()
  21. Catch ex As Exception
  23. 'Data connection could not be refreshed.
  25. MsgBox("Sorry, but I could not refresh the model! Are you sure this workbook has one?")
  27. Exit Sub
  29. End Try
  31. 'Refresh all PivotTables
  33. For Each ws In xlWorkbook.Worksheets
  35. For Each pvt In ws.PivotTables
  37. With pvt
  39. .PivotCache.Refresh()
  41. .RefreshTable()
  43. End With
  45. Next
  47. Next
  49. End Sub
  51. End Module

So far so good. Now I needed a user interface.

To be fair, it took me a bit to figure this one out. Once I finally realized that you need to open the “AddinModule.vb” portion in the solution explorer, then add a Ribbon tab to the canvas, then things got easier.

Despite reading very little documentation, with a little help from the blogs and articles on the Add-in Express site when I did get stuck, I was very quickly able to build a simple UI. There’s a good article on doing this here, which I wish I’d read earlier in the process.

As I say, it’s a really simple UI: a tab called “Model”, a single group, and a button with an image on it.

One criticism I do have is that it would be nice to be able to link the buttons and other controls to their callbacks inside the visual designer. As is, it’s a bit clunky, as you have to select the designer, then choose the other controls in the properties window. It’s not totally intuitive, but once you know where to look (read the article linked to above), it is workable.

My callback code for my button (which I didn’t bother renaming) is as follows:

  1. Private Sub AdxRibbonButton1_OnClick(sender As Object, control As IRibbonControl, pressed As Boolean) Handles AdxRibbonButton1.OnClick
  3. Call RefreshPowerPivotTables()
  5. End Sub

And with that done, it came time to debug. Again, fairly straight forward:

  • Build -> Build the project
  • Build -> Register ADX project
  • Make sure Excel is closed
  • Start the debugging engine

My “Model” tab showed up, with the command I’d built, as shown below:


And with a single click (and a bit of a wait since Power Pivot is so slow), my Power Pivot data was refreshed, and the PivotTable updated to reflect the changes I made in my database. Notice the new customer and the new sales transactions for 8/1/2013:


But the best part is this:

  • The solution is deployable to both 32 bit and 64 bit Office platforms, and
  • I can open my Power Pivot project even if I run my code first, and it doesn’t crash.

I can honestly say that I fought that Power Pivot crash issue for about 2 months with VSTO, and I was really worried that it was going to kill my project completely. No amount of searching would turn up a fix, and other help calls didn’t yield any gold either; where they were answered, it was with a “don’t know” answer. Add-in Express has actually made this goal achievable.

I’ll also tell you that, while refreshing Power Pivot isn’t the focus on my full project, I have been able to use Add-in Express to successfully target and manipulate Power Pivot in both 32 and 64 bit versions of both Excel 2010 and 2013. I.e. multi version deployment with one code base. Pretty damn awesome.

I should also mention that their support has been phenomenal as well. Not only have they answered my emails, but I even ended up on a call with one of their lead people to examine why I didn’t seem able to use the debugging tools at first (a blog post for another day). 30 minutes, problem solved, and I’m good to go. Again, pretty damn awesome.

Readers of this blog will know that I don’t endorse very many products at all. Sure, I use Google Adwords and stuff, but I don’t write too many blog posts talking about how awesome a product is. Here’s my word on Add-in Express:

I’m sold. This product has been a life saver, and I won’t develop using VSTO.

A new article, a new site host, a Facebook contest, an old blog…

It’s been crazy busy over here the past couple of weeks.  I’ve been hard at work creating 3 training videos for a client, (we shoot in Studio on Friday,) preparing for my next live course (this Saturday,) and trying to keep the forum posts all answered… among other things…

Excelguru has a new host

The biggest news, as far as the site is concerned though, is that we’re running on a new host.  My former host kept sending me messages about the server usage, asking me to block users and shut things down, as I was too busy.  They suggested that, if I didn’t want to do that, I should upgrade to their dedicated server plan.  I have to say I was a little shocked by that, especially when they told me it would move me from $4.95 per month to $164.95 per month.  While I love hosting the forums and site, that was a little much to swallow.

Instead, after some research and conversations with my friend Simon, I’ve moved the site to host with URLJet, a company that specializes in vBulletin and WordPress hosting.  They’re more expensive than what I was paying, certainly, but what a difference in service.  I signed up and within 10 minutes they called me to talk through the migration scenarios.  The site migration was finished, tested and working within 4 hours, all done by them.  They reviewd it, made some performance tuning changes, and recommended a few for me to do too.  Very cool, and all done at no extra cost.  I have to say that so far I’m really pleased with them.

We’ve been running on URLJet for a week now, and the site seems more responsive and forum posts are picking up.  I’m not sure if that’s coincidence (probably), but it’s getting to the point where I could certainly use more people on the site.  So if you love Excel or just want to learn, we have posts that need answering!  :)

The old blog is back!

As if moving my site and optimizing it for me weren’t enough already, URLJet also fixed the WordPress blog that I’ve been locked out of for 1.5 years too!  While I was planning on using the vBulletin blog, WordPress is way more flexible, and I didn’t want to lose all the old content so…

With this blog back live, I’m going to resume posting here.  I ported the two articles back from the vBulletin blog that were worth saving, so if you see those in your feed, just ignore them.  :)

A new article

In celebration of the whole thing, I also created a nice new article on the site as well.  If you’ve ever been confused about how conditional formatting rules are applied in Excel 2007+, I’ve written up a VERY detailed, step by step article that will walk you through exactly what happens.  You can find that by clicking here.

Facebook contest

My facebook page at http://www.facebook.com/xlguru is creeping ever closer to 100 likes.  I’d really like to make that milestone, so I announced last week that I’d give away a copy of my Magic of PivotTables video course to the 100th like.

I have to admit that I was hoping I’d be there by now, but then I got the following comment from Rick Grantham on Twitter:

“guess I need to unlike your FB page so I can like it back at the right moment.  Maybe I shouldn’t have told you that :)”

I had a good laugh there, but it did make me wonder… so I think I’ll change the game up.  (All those of you who are already Facebook fans can thank Rick (@BIStrategyGuy) for this….)  Here’s the new deal:

Be one of the first 100 likes on the xlguru page for a chance to win a free copy of my Magic of PivotTables video course!

Once I hit 100 likes, I’ll draw a random name from the first 100 people, and then I’ll send you a discount code to download a free copy.  It’s just that easy.  :)

See, now no reason to wait.  In fact, you might want to hurry, as there are 97 likes as I post this!  (But don’t worry, this won’t be the last one.)


PowerPivot And DAX Just Got A Whole Lot Easier…

As many readers of this blog will know, I am a huge fan of PowerPivot, and honestly believe that this is THE most important feature to hit Excel since VBA was introduced to the product. And anyone who has ever taken a course from me knows that VBA is the greatest thing to be added to Excel since the grid was mapped into rows and columns.

For those who don’t know, PowerPivot was a free add-in to Microsoft Excel 2010, and is now baked into the Excel 2013 release. It basically allows us to pull data from different sources (multiple databases, text files, web data feeds, excel worksheets and more) into a separate layer of our file, and create relationships between the resulting tables. Basically you can aggregate data from a bunch of different sources and EASILY aggregate it into your very own business intelligence engine.

The amazingly cool part is that it’s not hard to do this. With a little knowledge about relational data (and I mean a little), and knowledge of text functions like these, you can build the columns necessary to relate your data. From there you create the table relationship (PowerPivot even tells you if you try to build it backwards), and you’re off to the races.

The results of this are, quite frankly, groundbreaking. You can then build PivotTables off this data: PivotTables that are sourced from multiple tables at once. No more massive VLOOKUP tables to build one huge data table with everything. It’s simply no longer necessary. And with the variety of sources, you can even pull in and start adding items to your pivots that you never thought of before, like the weather for example. Does your corporate database have that? I doubt it, but who cares? Just source a weather feed from the internet, relate the dates to the dates in your sales table and presto! You can now see how sales were on the sunny days in a month vs the cloudy ones.

It’s amazingly easy to get some cool stuff out of PowerPivot… at least… to a point. To over-simplify things, I’d say that PowerPivot allows you to do four overall things:

  1. You can source and relate tables to build your own aggregated data source (a mini BI database if you like.)
  2. You can build PivotTables pulling in fields from multiple tables.
  3. You can build OLAP formulas, allowing you to pull data for a specific element right into the worksheet, without building a whole PivotTable to do it.
  4. You can build super duper wickedly complex and powerful calculated fields for your PivotTables using DAX.

To me, the first three were easy. As an Excel pro with a bit of relational database knowledge, I’ve been able to work through the first 3 over the past couple of years with very little in the way of roadblocks. And by doing so, I’ve built some amazingly cool things for our company. Yet despite this, I’ve always been aware that the real piece de resistance, the part that really makes things sing in PowerPivot is DAX.

What the heck is DAX? It stands for Data Analysis eXpressions, and is the formula language that you use to create what PivotTable users know as “Calculated Fields”. It is unbelievably powerful but, without tutelage, it is unbelievably hard. For almost two years I’ve been struggling to understand DAX.

That ended this past week.

Last week I bought a bought Rob Collie’s new book “DAX Formulas for PowerPivot: The Excel Pro’s Guide to Mastering DAX”. When you are ready to take the DAX journey, you MUST have this book.
Rob’s writing style is identical to that you’ll find on his blog at http://www.powerpivotpro.com/. In fact, the only difference is that he doesn’t fill up any real estate with movie quotes. :) What you do get is a huge amount of insightful information.

I can honestly say that, despite being a fairly accomplished Excel pro, I have been unable to wrap my arms around DAX. But that is over. Four days of working through this book with my own data and I am now making some damn cool stuff that eluded me before.

What I love about this book is that Rob sat down and carefully thought through how an Excel pro should learn DAX, then started at the beginning. It progresses logically, is very easy to read, and actually gets you there. Yes, you need to practice, but weren’t you going to do that anyway? And when you practice…

There’s something really important between these pages that I doubt you’ll ever see in the advertising. With any programming language (yes, Excel formulas fit that bill, as do DAX formulas) there are two critical things to learn. The first is Syntax (how you do something), and the second is how to debug something. Rob gives you both, which is critical on the path to mastery. He has some nice little charts that explain how filters are applied to the CALCULATE function, (which is like SUMIF on steroids.) With those charts, you can actually follow the steps to figure out exactly why your measure is not doing what you want. (Trust me, it was doing this that actually helped me finally get that Eureka moment that I’ve been looking for!)

Four days. I’ve gone from not being able to make anything but the most simple DAX measure to the point where I can create some pretty cool CALCULATE functions (my new best friend), with nested date/time intelligent functions as well. I’ve been pursuing that for TWO YEARS!

In an hour this morning, I was able to build a nice little “Server Contest” dashboard for our food and beverage department. It has slicers to drive down into sales areas, major groups (entrees vs desserts), and dates. And it will correctly report the week-to-date, month-to-date and prior weekly sales in units, as at the selected point in time. (Previously, I was able to get the “effective date” to work, and my “current month” to work, but I could never figure out how to filter things to give me the correct month to date number if I clicked an earlier date. It always kept returning the real month to date, rather than the effective month to date.)

The dashboard is a beautiful thing (to us anyway), that we’ve never been able to produce until today:

11-22-2012 10-38-01 PM

After struggling with DAX for so long, I think it’s fair to say that I wouldn’t have been able to break through this without Rob’s help. I certainly wouldn’t have been able to build the report above in such a short time.

If you’re struggling with DAX, or just getting ready to start the journey get his book. You owe it to yourself.

You can pick it up from Amazon.ca (for all my Canadian colleagues) by clicking here. If you’d prefer to deal with Amazon.com, you can get it by clicking here. And/or from other routes as detailed on Rob’s Website.


A few weeks ago I received an email which read in part:

I’m writing to you to make you aware of WinAutomation (www.WinAutomation.com), our software product (that includes a powerful macro recorder) that helps you automate your repetitive tasks (e,g. files, folder, database, web actions etc), so that you can save time, effort and labor.

In the name of full disclosure, the person offered me a pro version of their software if I’d like to blog a review of it. Actually, they even went further and offered me some licenses to give away to blog readers as well. It sounded like a pretty good deal to me, so I accepted.

Now, before I really give a review on this, I think it’s worth acknowledging that I’m not your typical user. When I feel like automating a task, I typically write the code to do it. I’d also say that the majority of those tasks are inside office, and I do very little in the way of repetitive tasks at the Windows Shell level.

WinAutomation does offer the ability to automate Excel to some degree and has an “Execute SQL Statement” ability to work with databases. Neither of those are any interest to me though, as I’d do both through VBA. I really don’t do any repetitive web actions either… unless you count opening bookmarks. So what could this offer me?

Basic Scripting

One thing that I was looking to accomplish was file sharing. I use Windows Live Mesh to write a critical file up from my laptop to the cloud and share it with a couple of people. The problem I had is that this file also needs to exist on the network, and I don’t want to install Windows Live Mesh on my file server. So I needed to come up with a way that I could copy this file to the network every time it was changed. WinAutomation does actually accomplish that need for me.

The interface doesn’t take too long to get used to, and in a short time I was able to knock up the following script:

Long story short, this checks if my network exists and copies the file to the network if it does, or notifies me if it isn’t copied. The script is set up with a trigger to monitor the source file and runs each time the file is changed. And I get a notification popup with the result:

This is pretty cool for me because LiveMesh syncs the file to the cloud, and WinAutomation copies it to my local server. With a Lenovo feature I can run an exe each time I log on to a specific network profile, and WinAutomation can compile the macro to an exe file for me.

Of course, if I don’t want to go the exe route, I can set up a trigger in WinAutomation to monitor the system’s “Application” event log and run the script each time a certain event is triggered. It gets a little tricky though, as you need to find an event that fires consistently after WinAutomation starts up, but it seems to me that the WinLogon 4101 event should work:


I am sorely disappointed in the variables that are offered. In the job above I really wanted to just set the files to variables at the beginning of the routines so that I could check properties of the files. I couldn’t seem to do that, though. For example I set a file into a file variable and a folder to a folder variable. Then I wanted to check if the file existed inside the folder… it was a non-starter, and pretty frustrating.

Macro Recorder

WinAutomation also has a Macro recorder. I tried recording a macro which:

  • Opened Notepad
  • Typed in some text
  • Opened Outlook

The results are below.

Honestly, I was a little disappointed in this. Maybe it’s because I’m used to using VBA and controlling an Object Model, maybe because I actively avoid using SendKeys… I picked Notepad off my “Most Recent” list, so I really wonder what happens when it changes position. Based on what I see below the macro would stop working… I don’t claim to be smart enough to offer a solution though, but then I didn’t write the program.

Recording file/folder actions through Windows Explorer yields the same issues with mouse clicks and SendKeys as those above. I find it a little weird that there is no warning to the potential of failure if the window wasn’t open in exactly the same place.

I can give an example of where the macro recorder is pretty useful though, despite the limitations above. You can set up a keyboard trigger (CTRL + ALT + SHFT + F for example). This worked well for some data entry I had to do when I was fixing a loyalty program setup today. I had to enter a category number and then enter data in about 12 columns for each category. The rub was that only the category number changed, and the rest was consistent data. So I recorded a quick macro, hooked it to the keyboard shortcut and then just had to enter the number and hit the key combo to fill the line. Much better. :)

Setting Triggers

The program certainly does have some power to it, and the selection of objects that you can program is fairly large. I didn’t have too much trouble creating jobs through the designer to do most of what I wanted, although working with the variables seemed pretty clunky to me.

The hardest part of working with this software though is coming up with the appropriate trigger for your macro. Here’s a list of the available triggers for completed jobs:

So the thing is that you need to get creative with how you set up the trigger. And what you want may not actually be there, so you may need to look at another route. For example, I thought about setting up one job with a ping trigger… but the ping trigger here only fires when the host doesn’t respond. I kind of wanted it where the host did respond. So I’m left hunting for another way to figure out if the server exists.

One case in point… Assuming that you are not using Windows 7 or a Lenovo computer, (both have built in functionality for this,) you may want to set a different default printer when you connect your laptop at home vs work. Creating the actual macro is super easy as you can see:

The real question lies in how you set the trigger… one way is shown below:

In browsing my event logs though, it looks like you can have multiple entries in the event log for WinLogon, so maybe it’s better to monitor a specific outcome. This one will kick off each time the Windows license is validated, which I think only happens right after you log on:

At any rate, setting triggers is the toughest part of this program. It takes a bit of getting used to, and can be pretty frustrating when you first start. A little persistence pays off though, and really starts to unlock some deep power.


I went through some ups and downs as I was learning to work with WinAutomation, with it sometimes feeling impossible to make it actually return the true potential it should offer. Building macros is actually very easy using the drag’n'drop interface provided. But the real key is to not give up on the triggers portion and look at things in different ways until you find one that works.

To me the “SendKeys” style output of the macro recorder is a big disappointment, but despite that, it still offers the ability to knock up some quick data entry features in programs that don’t otherwise support any automation. That value cannot be overstated as it can save you tons of time.

The more I work with this program, the more I do find uses for it.

Free Licenses!

So… would you like to try it? They have generously provided me with 3 licenses to give away.

Here’s how it works…

  1. Send me an email at ken at excelguru dot ca with the following subject: “WinAutomation Giveaway”. (If you don’t get it right, then you won’t be entered. ;) )
  2. I’ll take all the valid entries received between now and midnight Pacific time on Tuesday, October 27, 2009
  3. All valid emails within the timeframe will be entered in an Excel spreadsheet
  4. Each entry will get a RAND function beside their name
  5. I’m going to sort them, and whomever comes out in the top three wins

Backup Strategies

As the IT guy at work, I’m responsible for making sure that we’ve got good backups available in case anything goes wrong. Like many corporations we use tape backup which we rotate off site. It works reasonably well as we’ve got it down to a routine, with daily and weekly backup tapes, ensuring that we can roll back 1-5 days or 1-5 weeks. (Or less, as we also use ShadowCopy on our servers.)

At home though, it’s a different story. I find its way harder to get into a backup schedule at home, for a variety of reasons. Despite making sure we have backups at work, I’ve been notoriously bad about backing up the data on my personal machines.

This obviously leads to the inevitable “What If” questions… what if the house burns down? What if a computer was stolen? What happens if I lost my laptop? What happens if we have a catastrophic hard drive failure? What if… So last week I decided to actually deal with this issue.

Acronis True Image

I installed a copy of Acronis True Image (an older version) that Acronis was generous enough to provide to me a year or so ago. I managed to backup my laptop to an external USB hard drive, which was great. But there’s this thing about backups… as my friend John once said “The value is not in the backup, it’s in the restore.” To complete a backup test, I decided to restore it to another machine that I have in the office.

It was a no-go. Not the fault of Acronis, to be sure. I’ve heard great things about their products, and I’m sure it would have worked just fine. The issue is that I backed up 200GB of stuff, and the machine I could mess around with only has a 75GB drive. It just won’t fit.

So I’ve still got that backup, but it’s not really as portable as I want. And while the new version of Acronis has a “set it and forget it” feature, this one doesn’t. So that still leaves me needing to manually trigger backups which, as I mentioned earlier, I’m not very good at remembering to do. So I gave up on Acronis, looking for a better solution.

One thing I would say about Acronis is that I’m not really a fan of the restore interface. It strikes me much like the old Norton Ghost versions which aren’t quite clearly explained. I don’t use this product much, so what I’d like to see are screens that read something like the following:

  • What file would you like to restore FROM?
    • Show the list of drives, but mark which are internal and which are external drives
  • Where would you like to restore TO?
    • Show the list of drives, again mark which are internal vs external
    • Clearly explain that the drive you select here will be overwritten

I just really didn’t find it was worded quite like that, which made me a little nervous.


So at any rate, I kept looking, and re-visited Mozy, eventually holding my breath and shelling out $9.90 for a month of backup to test it out for our PC’s.

Mozy seems pretty slick. It basically works like this:

  • Flag the files you want to back up
  • It compresses and encrypts them
  • It uploads them to Mozy’s server
  • They are available to restore

The actual backup interface is pretty simple, and you can pick the speed it uploads at if you want to scale up/down your upload speeds. The shot below is a backup in progress. Keep in mind that I don’t have much bandwidth here at home, since I’m running over a wireless G connection.

There is something misleading about the image above though… You’d think that pressing “Cancel Backup” would actually cancel the backup. It doesn’t. It stops it temporarily, as you can see below:

I also tested the restore. Again, the interface is pretty simple, as you can see below:

It took about two minutes to “find the file on the server”, and then the restore of the file was pretty much instant. The file works just fine.

Some of the things that really sell me on Mozy are:

  • It has “set it and forget it” scheduling. Set the backup files and it just works away in the background
  • It is on a remote server. So I don’t have to remember to burn discs or write to tape and take it away
  • It only backs up the changes going forward, so it won’t consume all my bandwidth while I’m trying to use it

One thing to be aware of though, is that you do need bandwidth to upload your data to their servers. Dee’s backup is over 12GB, and has been working for about 2 days now to send it all along at about 800kbps. That may seem like a lot of time, but the peace of mind of having the family photos backed up is worth it.

My Verdict

I’m pretty frugal when it comes to my software, but so far, I’d recommend this one. I think it has some serious advantages over traditional backup methods, gives good peace of mind and, at $4.95 per month for unlimited backup for home users, it’s pretty affordable.

If you’re interested, you can find out more at www.mozy.com/home.  I was also made aware by email of a full review at onlinebackupsreview.com, where you can also save 20% with a Mozy Promotional Code.

Windows 7 install

Last night I decided to install Windows7 RC on a spare laptop hard drive. So I pulled my Vista drive out of the laptop, slipped in the other drive and away I went.

For reference, I found the install very slow compared to XP or Vista. It seemed to take forever and a day to install it. Oh, and just as a note, you need to license code before it will boot into Windows (duh!). I had to run to my wife’s computer to grab a code from MSDN as I kind of forgot that little part.

I’d already installed this on a desktop PC, and found some interesting new features that look nice:

  • Screen Magnifier tool (no more need for the magnifier that comes with my mouse software?)
  • Sticky Notes (stick right on the desktop)
  • Live Preview of application pages/windows from the task bar
  • Clipping tools (competes with SnagIt/GrabIt)

Interestingly enough the screen magnifier and live preview did NOT work well on my laptop, where they did work on the desktop.

I’ll also say that the version of IE8 included with Win7 sucks. On both the desktop and laptop it crashed repeatedly. I ended up restarting IE8, clearing 2 error messages and going straight to Firefox.com to download a useable web browser.

Windows Live Mesh will not install on Windows7 at this time. That’s a bit of a problem for me as I keep some pretty critical documents there to make sure I have a backup of them.

Upon shutting the laptop down last night I also ended up triggering the blue screen of death… I haven’t actually seen one of those in a long time.

Of course, I had to work today, so I pulled the Windows 7 drive out and put my old Vista one back in… and just about had a heart attack! The BitLocker drive encryption screen came up. I’ve never actually seen that before, as it doesn’t actually appear to do anything when you turn it on. The momentary panic passed though when I verified that the key I had tucked away was the right one, and I’m up and running again.

Blogging to WordPress from Microsoft Word

So based on Johan’s comment on yesterday’s post about this being easy, I decided to give it a shot. So far, with the exception of a boneheaded move where I tossed a virtually complete post without saving it, I’m pretty impressed at how easy this seems. I’ll know for sure if this appears live though.

For lack of better content to test with, I figured I’d give a step by step guide to setting this up. J Okay, seriously, it also shows how easy it really is, and gives me a good excuse to try all kinds of formatting, such as Styles, images, URL’s, numbering, and smileys. ;)

So here we go…

Creating a Blog Post – Part I

To start with, I simply went to the Office Menu, chose to start a New file, and chose Blog Post, then Create:

Registering Blog Credentials

At this point, I was greeted with a (hopefully) one time setup wizard to “Register My Blog”. (Basically tell Word where my blog is, and what the login credentials are to publish content.) Here are the steps to making it happen.

  1. First, you need to choose your blog provider from the list shown below. Fortunately, WordPress was in the list, so I didn’t need to create my own:


  2. Next, you tell Word where your blog is located, and provide your login credentials in the box below:


    NOTE: I think the Word team did a good job with this by putting the <Enter your blog URL here> part, as it makes it really obvious where it goes. For me, this was pretty simple to complete, (http://www.excelguru.ca/blog). Hopefully you’ll know your login credentials for your own site. ;)


  3. Just to be thorough, I also decided to check the Picture Options. I actually ended up going with the default of My Blog Provider, so we’ll see if it works.


  4. Click OK a couple of times, and the blog registration is done.

Creating a Blog Post – Part II

Okay, so now that we’re done with the setup intermission, I’m dumped into a blank Word document with the following:

Again, it was pretty obvious what to do!

  • As you can imagine, I selected the text above, changed it to Blogging to WordPress from Microsoft Word.
  • Finally I dropped below the line and started composing my post.

Adding a Category

Of course, we also have Categories in our blogs. In the UI, there is a place to select those, so I figured I might as well try that too. I clicked the Insert Category button.

I had to clear a login box to the blog, and after that nothing seemed to happen. I clicked it again… still nothing. Again… (like anything was going to change, but I like to do stupid things like that sometimes…)

Finally, I scrolled back up to the top of the document… aha! It had inserted some fields for me to play with under the title!

So I picked General, Software Reviews, and Office 2007. J

The End Result

All right, I’m not going to tell you what I typed, as you can already see that. (Remember that I’m still writing, so I don’t even know if this will make it to the blog, although I have some faith it will!)

What I am going to do is quickly summarize the stuff that I believe is important in this post, to see how it comes through. This is partly notes to me, so I know what the original Word document looked like before I posted it, as well as notes to anyone else who is interested…

Paragraph / Line beginning…

Items of importance

Why it’s important

For lack of better…

Contains a happy face, and a winking icon that translate into smileys in WordPress.

First, I want to see if it interprets smiley faces. Second, the happy face (colon + closing parenthesis) already converted to a happy face in Word, while the winking still shows here as a semi-colon and a closing parenthesis before publishing. (Actually, you can see the smiley in the category image just above.)

Creating a Blog Post – Part I

Done in the Heading 1 style

How are heading styles implemented?

To start with…

Contains words formatted in bold, and is followed by an image

How does bold formatting implement, and how are images in Word dealt with?

First, you need to…

Contains numbering

How is numbering implemented?

At this point…

Contains “smart quotes”, not plain old regular ones

These were apparently an issue in Word Beta2, so I want to see if they were truly fixed.

NOTE: I think…

NOTE is in red, the entire line is in italics, it contains a URL, and a smiley set (in italics this time though.) It also contains the “greater than” and “less than” signs around the “Enter your blog URL here” phrase.

The greater than and less than characters can be problematic, as they are typically characters that indicate code, particularly in XML. I’m also curious to see how more complex (overlapping) formatting works.

“Enter Post Title Here” picture

Has a border around it in Word.

The rest of the pictures were snapped (by the world’s best screen capture program; SnagIt), and pasted into Word. This is the only picture that was changed by adding a border to it.

As you can imagine…

This line, as well as the following one, are bullet points. In addition, the Blogging to… title was underlined.

The underline was just to check formatting. I was more interested in seeing how the bullets would be implemented.

This whole table

Is a table

How are tables implemented?


And there you go! I’m going to hit Publish now, and see what happens!

This is a post about speech recognition

I tried to set up my laptop today to use the speech recognition native in Microsoft Windows.  I found it pretty hard to actually get it to recognize my voice the first time around.  It doesn’t actually feel quite as efficient as typing right now, but I’m sure that it will get better with time.

It’s very apparent that it’s quite powerful, but it feels quite clunky to try and talk to your computer to begin with.  I also found myself correcting an awful lot of mistakes where the computer misunderstood me, and that in itself was quite painful.

Probably the most frustrating part, however, was I had to do this speech recognition in Microsoft word as it could not be done in Firefox.  (I was trying to post to the WordPress blog.)

Despite the pain, I persevered and this blog post was completely dictated.  I will also be attempting, using voice commands alone, to actually copy and paste this in the blog.  If it shows up you’ll know I was successful.

Something tells me that I need to get Word to post directly to my blog which I understand can be done.

File Sharing Technologies

Over the past while, I’ve been trying to solve a business need with some file sharing technologies.  There’s some neat things out there for this purpose.  The irony of the ones I’ve used, however, is that they are 3 distinct products, all made by Microsoft, and each of which treats things slightly differently.

Before I get into the software, here’s the issue I’ve been facing:

In addition to being the Controller at Fairwinds, I’m also the only on-site IT guy.  It’s therefore up to me to make sure that I’ve got all the information, when needed, where needed, in order to restore the systems should they go down for any reason.  And while I may call in outsourced techs to do the dirty work in restoring things, it remains up to me to be able to provide them with the information that they need.

I have a few really important documents that I basically need to be able to get to.  While I have remote access to my system, the issue is that it’s when the systems are down that I need the docs most, and I can’t get to them.  So basically, this meant that I need to create my Critical Info Document, save it (password protected) on my laptop, and save it to the server.  When I go on vacation, my boss needs a copy, and it then becomes important to make sure his is up to date, just in case he’s ever contacted because I’m unavailable.  I also want to share a copy with my outside support consultants so that they can deal with issues without me, should they need to.  (They are trustworthy and professional.)
So now I have several copies of the document that I need to maintain.  Maybe it wouldn’t be a big deal if the document wasn’t as fluid as it is.  But that’s neither here nor there as the reality is that it gets updated at least once a week, and sometimes once a day.  Saving and emailng copies of this document is not desirable from either a managment or security point of view.
So, enter the file sharing technologies.  Here’s the ones I looked at:


Groove has a bunch of uses including sharing calendars, sketchpads, and documents.   You can also set up full File Sharing folders to sync up between PC’s.  I looked at this very quickly, as it costs to install Groove on each PC.  In addition, because Groove is a big program, it feels a bit “heavy” if that’s all you want to do.  Of course, to access your files, you need to log on to a computer with your Groove account installed.  I’m also not convinced that you’ll get updates unless at least one user is online that you can sync to.  I’ve been told otherwise, but haven’t tested that for myself to date.

Don’t get me wrong, Groove is a great program, but I wouldn’t buy it if all you want to do is share files.

Windows Live FolderShare

FolderShare is a Windows Live Beta technology.  Pretty neat stuff, as you can create libraries to share between PC’s, libraries to share with other users, and even use the internet to access the files on your PC from a remote site (if it is on.)  What is cool here is that, when sharing a folder, you can invite others to it, and give them a variety of rights from read only to full editing.  It seems pretty light-weight and works fairly well from what I’ve seen.

The drawback here is that, if you are at a remote site without your PC, and it doesn’t happen to be on at home or in your office, you can’t access your files.  Maybe not a big deal to you, but if I need access to my Critical Info Document and all I have access to is an internet cafe…

Windows Live Mesh

This one is actually pretty cool, classified as a “Tech Preview”, which I believe is before even Beta.  It’s got all the benefits of FolderShare, and adds a couple more components.

Mesh has 5GB of storage “in the cloud”.  (Read as on Microsoft’s servers.)  So basically, when you connect to the internet, your selected folders sync up to the storage in the cloud, then down to your other PC’s.  This means that you can access your files over the internet, even if none of your PC’s are on.

And if one of your PC’s does happen to be on, throught the net you can remote control it, just like you would using a program like LogMeIn.

Mesh also displays a nice little message that synching with a mobile phone is “coming soon”.  That will be a pretty cool feature to add.

Some of the drawbacks with Mesh, at this point:

  • When inviting others to share a folder, you have to give them “Owner” rights.  That kind of sucks, as it would be nice to be able to decide who should have Read Only rights.
  • It’s a little bit awkward to set up synching folders, IMO.  Could be a bit cleaner.  Once you get used to it, it’s okay, but it’s not really intuitive.
  • “Non-US” customers are not eligible to sign up for an account, and they validate your email address to make sure it ends in .com ;)

A Security Perspective…

One of the things that I found ironic about these technologies is that you can’t share network drives.  I’m guessing that this is probably designed around security concerns, as we wouldn’t want all of our users sharing critical work files, would we?

Instead, we now push our users to save into non-network folders, which usually aren’t backed up, and push the storage to personal computers outside the company control.

Things I’d Like To See

Now, thinking about my critical information document that I share with consultants, it would be awesome if these technologies could be set up to do the following:

  • Prevent users (depending on permissions) from copying out of a folder that they have been given access to.  (I wouldn’t want them sharing with all their friends.)
  • Allow for a way for the owner to revoke files from an invited user.  (If I were ever to discontinue using these consultants, how can I assure that they lose access to my info?)

Go TomTom Go!

A couple of weeks ago, I took the most relaxing vacation of my life.

My family and I went to the Okanagan Valley and spent some time in Osoyoos BC at Walnut Beach Resort.  It was purely awesome, and I think we’re just going to have to go back there next year.

So what made it so relaxing?  From the time I left work on the Friday afternoon until I returned to work on the Monday a couple of weeks later, my laptop was turned on twice… both times it was so my wife could read her blog posts.  For the very first time in my life, I shut off for my vacation.  It was something I badly needed to do, but honestly never thought I could.  I didn’t even check my email on my smartphone or anything.  Pure bliss, seriously.  (The place was awesome too, as was the weather.)

One of the things that I did do on my vacation was to really use my TomTom Go 920 on a regular basis.  I’d used it to drive to/from work (like I don’t know the way), and it seemed to work pretty well.  On vacation, though, now this was a serious test!  So here’s my feedback on GPS (this is the first one I’ve ever owned), and some specifc TomTom features.

“Go Confidently”

This is actually TomTom’s tagline, and couldn’t be more appropriate, as far as I’m concerned.  When driving around, I never had to worry about getting lost, as TomTom could always get me back on route to my ultimate destination.  It allowed me to drive to Victoria last weekend with no concerns about having to read a map, and allowed us to find our hotel with ease in a city I’d never spent time in.  One day, when we showed up an hour early for a B&B, we decided to go exploring.  Not a concern in the world as we headed off the beaten track.  We saw some REALLY out of the way countryside, TomTom constantly re-routing to let us know how to get back to the B&B when we were ready.  I’d NEVER have done that, or seen those roads, without TomTom on board.  Very cool.


This isn’t a knock on TomTom so much as it is on general GPS technology.  The device will get you close, but you need to do the final looking for your destination.  The route is easy, but the last 50-100 metres can be a little confusing.  I think it’s because a lot of places are plotted on the map by their street address, but as we all know, that sometimes doesn’t actually match exactly to their physical address.  (Driveway on the side road, mall stores are particularly difficult, and addresses where houses are tight together don’t have to the foot accuracy.)  I hope that over the next few years that this can be improved overall, and would further suggest that it will be user communities that make this happen.  And fortunately TomTom has done some work in this area.


Correcting the actual location address of a “Point of Interest”(POI) is pretty easy in TomTom.  I managed to “move” the Fairwinds Centre (where I work) to it’s actual address fairly easily.  (It was off by about 100metres when I first got it.

Unfortunately, while moving POI’s is easy, I had bigger hopes for updating the map.  TomTom has “mapshare”, which leads you to believe that this should be easy, but I’m not convinced.  My subdivision is not accurate, with a new road being put in that isn’t on the map, and another road being moved.  Neither road is straight, which adds complications.  I was really hoping I could delete two roads and re-create them in the right place.  It looked like I did, but those changes don’t seem to take effect, despite the fact that I made them, and have asked to have all map corrections.

Adding roads at all is painful.  (Why can’t I just turn something on to say “start here and track me as a drive” then “end here”?)  The worst is that without the immediate feedback on my map, I have no reason to give this feedback.  I’ll correct all of Nanaimo if you let me… just let me!

Distant POI’s

Not all POI’s are in TomTom’s database, so you need an easy way to find remote POI’s.  I struggled in this area as well, as I seemed to need to know which city things were close to.  So I’m trying to locate Fintry Provincial Park, which is across the water from Kelowna.  I tried looking up FIN with Kelowna as the closest point… no luck.  Then I tried near Westbank… no luck.  Now, I know about where it is, but I couldn’t find a way to pull up a BC map to try and drill down.  The software needs to have a way to do this.

Itinerary Planning

This is kind of a neat feature, but again needs some work, I think.  I laid out our entire vacation in the planner, then saved it.  And since it has the abilty to set waypoints along the route, I did exactly that.  Great, but…

I treated my waypoints as somewhere I wanted to stop.  TomTom seems to treat them as somewhere to pass by.  I suppose this makes sense, but it doesn’t totally work due to the accuracy issue I mentioned above.  At one point, we stopped at Manning Park and, in fact, drove all through it.  I’m not sure where the address TomTom picks up for Manning actually is, but it never marked as visited.  So as we’re driving away, it tells me I need to pull a U-Turn.  It took me a bit to figure out that Manning was never marked as visited.

By contrast, in Naramata, where the wineries are next door to each other, it was marking them as visited before we even found them!

Problem solved by marking them all as destinations, as I actually had to manually select each destination I wanted to visit.  I guess if you just want to use the waypoint to route yourself a specifc way, then it would work well.

A really good thing with the planner, though, is that you can save and recall multiple itineraries.  So we ended up setting one up for each day we did wine tours.  I can look back in TomTom and see which wineries we went too, and where they were.  Yes, we hit that many!  :)

Funny Things

While TomTom had a TON of wineries in it’s list, the Okanagan Valley has many new ones.  Because of this, we had to set some destinations without the aid of a POI.  I don’t know who you’d point at for this, but I found that the local maps seemed to have roads by local names, where TomTom had different names.  (i.e 325th Street was shown on a local map as #11 Road.)


Love the fact that you can customize the voices, and the “Quick Start” screen, but I wish you could add specific items to the Quick Start.  There are a few things you can add, but they are pretty specific.  I’d like to be able to choose what I want there, such as a “Next Itinerary Destination” button.

QuickGPSFix is awesome.  Where the GPS Unit would normally take a minute to locate satellites, if you sync to the QuickGPSFix, it downloads the satellite positions for you from your PC.  Then when you get in your car it takes about 5 seconds.  Pretty cool there.

The hands-free functionality works pretty well when linked to my Bluetooth phone, although my wife tells me that I sometimes sound like I’m underwater.  Moving the GPS closer did fix that a bit, but you can only move it so close before you start getting it into your driving view.

The only other comment I’d make on the phone is that it’s not ideal if you are making a call to somewhere that has an extension.  If you can quickly call up a screen on TomTom to dial the extension after the call has been answered, I haven’t found it.  (Not that I’ve generally put a lot of attention to it, as I’ve been driving.)


Any qualms I’ve raised above are minor compared to the awesome benefits of having this puppy in the car.  I love it, and would recommend it to anyone.  :D