A1VBCode Forums

Losing Reference to MSCOMCTL.OCX


http://www.a1vbcode.com/vbforums/Topic31364.aspx

By macroman - 4/16/2012

Hi,

I have a series of add-in macros that rely on the Listview control and I have experienced a re-occurring problem since we "upgraded" to Excel 2007 or Excel 2010... it seems like the vbproject is losing reference to the above referenced .ocx file... it happened again today and I had to click on References and Browse to that file in System32 folder and that re-established the reference, but I can't keep doing this or expect my fellow employees to figure out how to do this. Is there a better solution, other than to quit using Listview?

Update - workarounds in progress; regsvr32 mscomctl.ocx has restored the macros but not clear how long that will last, re-wrote code to use a listbox instead; it's not as slick as the listview control but since it's a vba built in component and doesn't need a reference I'm going to go with that. Cool