Referenece Library

[Greg Maxey]

I was working on a UserForm and sent a copy to a friend for review. He told
me that it wouldn't open on his machine. He said that the reference to
Microsoft Windows Common Controls - 2 6.0 (SP4) was not present. He then
created a reference to Microsoft Windows Common Controls 6.0(SP6) which
overcame the initial problem.

We are both using Windows XP Pro SP2. I just verified that I am up to date.
I assume that he is but I haven't asked. When I go to tools>references,
Microsoft Windows Common Controls - 2 6.0 (SP4) is present but Microsoft
Windows Common Controls 6.0(SP6) isn't. What could be going on here? Which
is the more current version of Common Controls and if I am out of date, how
do I get updated? Thanks.

 

[Jonathan West]

Your friend has VB6 installed and has (perhaps unwisely) installed Service
Pack 6 on the machine. (Unwisely because SP6 seems to have caused more
problems than it fixed, at least according many of the VB MVPs.)

You are running into the well-known phenomenon of DLL Hell, where different,
slighlty incompatible versions of the same DLL are availeble in different
places, without you having any means of controlling the situation. The MS
common controls and common dialogs are particularly vulnerable to this.

I would recommend avoiding using any of the controls in the Windows common
controls for this specific reason. Which one were you using? There is
probably a free alternative somewhere, most likely at http://ccrp.mvps.org