Programming Style Etiquette

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

George Lee - 08 May 2006 00:49 GMT

I know Word is buggy and the workarounds can be less than elegant at times.
However, I recently ran across a confirmed error in the Find function
(http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B29274).
Microsoft's suggested workaround is to declare ranges that need the Find
features to be declared with late binding (Dim myRange as Object).

Since the bug shows up unpredictably on user's computers (many of which I
will have no influence over), does this mean I have to change my programming
style and *always* use late binding forever more?

How do others address issues like this?

Reply to this Message

Jezebel - 08 May 2006 02:25 GMT

The article recommends late binding only if you are referencing the Find,
Replace, Dictionary, ReadabilityStatistic, or ReadabilityStatistics objects.
There's no need otherwise.

It's also a fairly arcane problem. Excel 5.0 is pre-1997. There can't be
many users who have registered the Excel 5 library *after* installing Word
97 or later.

If you are creating code to run on users' machines, you *do* have influence
over them. Re-registering the Word library is surely no harder than
installing your code?

>I know Word is buggy and the workarounds can be less than elegant at times.
> However, I recently ran across a confirmed error in the Find function
[quoted text clipped - 8 lines]
>
> How do others address issues like this?

Reply to this Message