Visual Basic Code , VB.NET Code, VB Code
  Home   :  Code   :  Forums   :  Submit   :  Mailing List   :  About   :  Contact


Losing Reference to MSCOMCTL.OCX


Losing Reference to MSCOMCTL.OCX

Author
Message
macroman
macroman
Forum God
Forum God (11K reputation)Forum God (11K reputation)Forum God (11K reputation)Forum God (11K reputation)Forum God (11K reputation)Forum God (11K reputation)Forum God (11K reputation)Forum God (11K reputation)Forum God (11K reputation)

Group: Forum Members
Posts: 71, Visits: 264
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

 

Edited
4/20/2012 by macroman
GO


Similar Topics


Reading This Topic


Login
Existing Account
Email Address:


Password:


Social Logins

Select a Forum....

















A1VBCode Forums


Search