I have been working on a Excel workbook with lots of VBA code for a while & now I have sầu skết thúc this file to some colleagues for testing và it does NOT work in their computer.We all work in the same company & have Windows XP.. SP2 with Office 2003.

Bạn đang xem: Object library invalid or contains references to object definitions that could not be found

The workbook has a khung that opens when clicking over a shape và it contains some controls.When they cliông chồng over the shape for the form lớn show the following error appears:

"Object Library invalid or contains references khổng lồ object defintions that could not be found"

In the khung there is a DatePicker and I think there lies the problem. If I delete the datePicker from the form và skết thúc them the tệp tin again they bởi not get this error message.

I already tried deleting the mscomct2.exd tệp tin as mentioned in this two sites "Microsoft" và "lessanvaezi" but the error stil pops. I checked & the new .exd file was generated.

Xem thêm: Phần Mềm Auto Clash Of Clans, Hướng Dẫn Cài Đặt Và Chạy Auto Mybot Coc 2019

Some Additional info:

I check their system và they bởi have sầu the file mscomct2.ocx in the correct location(c:WinxpSystem32).If I open a empty Excel tệp tin, go khổng lồ the VBA editor go to Tools->Reference, I bởi vì NOT see the option lớn register the "Microsoft Common Control-2 6.0 (SP6)" (mscomct2.ocx). Instead I see a "Microsoft Windows Comtháng Controls Satellite-3 6.2)" (cmct3de.dll).I send my collegue the tệp tin with the datePicker, but without the reference to lớn the "Microsoft Comtháng Control-2 6.0 (SP6)". Before clicking the shape & opening the khung I tried to lớn reference the MSCOMCT2.ocx library dinamically with the following code. It referenced the "Microsoft Common Control-2 6.0 (SP6)" but the error still pops.

Sub RegisterCtl()

"MSComCt2.ocxstrGUID = "86CF1D34-0C5F-11D2-A9FC-0000F8754DA1"ThisWorkbook.VBProject.References.AddFromGuid guid:=strGUID, Major:=1, Minor:=0 end Sub

If I then go khổng lồ the khung in the VBE editor và rightClick on thetoolbox và then go to theAdditional controls lớn add the"Microsoft Date & TimePicker"control, I see that option listedTwo times. Unfortunatelly regarlessof wich one I cchose, the behaviouris the same: The datepicker symbolis added in the toolbox, but when Idrag the control khổng lồ the size, amsgBox pops saying that the controlwas not available.

Has anytoàn thân an idea what is wrong? What can I vì to lớn make it run in their computer?

I appreciate any help.


The computer with this problem has been Upgraded so I wont be able to lớn find the specific solution for my case. I"m choosing Archers solution as it has helped the most people (Most Upvotes).