Programming Style Etiquette

G

George Lee

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;en-us;29274).
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?
 
J

Jezebel

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top