Office Assistant object model examples

In Office Assistant and MsgBox Menus, Ramachandran Pillai has some useful examples for automating the Office Assistant and reading return values, like a cartoon MsgBox.

What isn't mentioned is that this will only work for versions of Office prior to 2007, because the Office Assistant has been removed in Office 2007 (and I assume that trend will continue in Office 2010).

Another issue to deal with is, what if the Office Assistant isn't installed? I didn't see an install check as part of the code. You won't be able to automate the Office Assistant if it isn't installed, so you'll need to either try to instantiate it and check for an error, or some other method I haven't thought of. The end user may be prompted to install it, which could be inconvenient for your application (and your users).

Another useful article with sample code may be found at TechNet Script Center.

My recommendation (and I'll take yours as well) is to avoid the gimmicky and out of date Office Assistant and use message boxes instead. I've provided a VBA MsgBox replacement here.

About JP

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 to learn more about VBA. Keep Reading »



Share This Article:

Share and bookmark this articledelicious buttonfacebook buttonlinkedin buttonstumbleupon buttontwitter button

comment bubble 1 Comment(s) on Office Assistant object model examples:

  1. Not to mention that you might stir up suppressed hatred towards clippy. Who wants to put poor clippy through that again?

This article is closed to any future comments.
Excel School