hlev
07-26-2010, 07:46 AM
Hi, I've got an .xlam add-in which have worked fine before, but now throws the error in the thread title when opened.
This error seems to be invoked by certain forms that use either ListView or ProgressBar controls from Microsoft Windows Common Controls 6.0 (SP6), system32\mscomctl.ocx
The reference to the library is not missing.
Apart from VBA is unable to compile the project, the error results in the forms not display properly in the editor on my machine, whereas they do and the add-in runs fine on a fellow colleague's computer. (Both running Office 2007)
We have cross-checked the versions of MSCOMCTL.OCX and COMCTL32.OCX, they mismatched, my ones were newer.
I have unregistered both libraries with REGSRV32 and replaced them with:
MSCOMCTL.OCX: 6.1.97.86 -> 6.1.97.82
COMCTL32.OCX: 6.0.81.6 -> 6.0.80.22
and then re-registered them.
This did not fix the error.
The symptom is if I try to add a ListView control to any form, or load an existing form that contains one, VBA throws the aformentioned error.
Any idea is much appreciated, I couldn't find resolution after browsing several google or ms support articles. Thanks.
This error seems to be invoked by certain forms that use either ListView or ProgressBar controls from Microsoft Windows Common Controls 6.0 (SP6), system32\mscomctl.ocx
The reference to the library is not missing.
Apart from VBA is unable to compile the project, the error results in the forms not display properly in the editor on my machine, whereas they do and the add-in runs fine on a fellow colleague's computer. (Both running Office 2007)
We have cross-checked the versions of MSCOMCTL.OCX and COMCTL32.OCX, they mismatched, my ones were newer.
I have unregistered both libraries with REGSRV32 and replaced them with:
MSCOMCTL.OCX: 6.1.97.86 -> 6.1.97.82
COMCTL32.OCX: 6.0.81.6 -> 6.0.80.22
and then re-registered them.
This did not fix the error.
The symptom is if I try to add a ListView control to any form, or load an existing form that contains one, VBA throws the aformentioned error.
Any idea is much appreciated, I couldn't find resolution after browsing several google or ms support articles. Thanks.