Automate Office Task Pane with Active Accessibility

The background Almost every Office application provides a powerful object model(OM) to allow developers to programmatically access its functionalities. However, there are always things that are inaccessible from OM. And a lot of task panes fall into this category. For example, in Office XP and above, there is no direct way to clear the contents…

13

Programming Office Commandbars – get the ID of a CommandBarControl

The FindControl(FindControls) method of CommandBars collection/CommandBar object is the most useful and reliable way to get the reference to a CommandBarControl object. For built-in menu items and toolbar buttons, the control ID is required for a successful call to FindControl(s). The following VBA code snippet will list control IDs of all available CommandBarControl objects(i.e., menu…

5

Programming Office Commandbars – how to disable shortcut menus

This is one of the FAQs about Office Commandbars. For some reason, you may want to suppress the shortcut menus brought up by right-clicking the content of an Office document. This is an example of how to disable them in Word: CustomizationContext = ActiveDocument Dim bar As CommandBar For Each bar In CommandBars If bar.Type…

1

SimpleBlogger update

A new build is available for download. Here is the information:   Form Version Release Date Backward Compatible Changes (thanks to) 1.0.0.252 (Current) 08/09/2004 Yes fixed reload categories  (G. Andrew Duthie) allow saving credentials with form  (G. Andrew Duthie) removed useless links to comment entries   Please see the original post if you want to…

4

ALT-Click – A quick and easy way to use Word 2003 as a (bilingual) dictionary

If you don’t know what I am talking about, try it now in Word 2003. Hold down ALT key on your keyboard then click a word inside a document and watch the Research task pane. With the default search scope of “all reference books”, entries for this word found in Encarta, Thesaurus and Translation will be returned in seconds….

1

A simple InfoPath blog editor for .Text – SimpleBlogger

About SimpleBlogger is an InfoPath based blog client utilizing the simpleblogservice API provided by .Text. Main functionalities are: view current posts; edit existing posts; create new posts; view comments.   Feature highlights In fact, those mostly are benefits provided by InfoPath. SimpleBlogger does very little. Standard editing features found in most Microsoft Office products, but…

92

Layout repeating elements horizontally in InfoPath 2003 SP1

In InfoPath, you can use repeating tables or repeating sections to display repeating elements. However, those two controls only allow elements to be arranged vertically. To illustrate, assuming the following data is bound to a repeating table:   <myGroup> <myRepeatingElement name=”element1″ value=”value1″/> <myRepeatingElement name=”element2″ value=”value2″/> <myRepeatingElement name=”element3″ value=”value3″/> <myRepeatingElement name=”…” value=”…”/> </myGroup>   The table…

0

Now that I am ready to blah…

Finally I got my InfoPath blog client for .Text working as expected. Before I talk about it in details and share it with you, I’d like introduce a little about myself.   I am a tester in the Office Management and Updating Services team, formerly known as Office Sustaining Engineering Services. Our main job is…

2