Object library invalid or contains references to object definitions that could not be foun

[thecdnmole]

I am getting this vba error with a spreadsheet that has macros on a laptop which it used to work on as of Dec. 10th! It is running the same Excel, 2010 as my home computer, the only difference is my home computer was 32bit windows and the laptop has 64bit. This same spreadsheet works fine on the desktop computer! I have tried deleting the .exd files, but that did not help. I also have come across to unregister the MSCOMCTL.OCX file and then register it again, but I have not tried this yet as it is in the folder but I did try but did not have any luck, the reply was the file is not found. Any other ideas out there that will help? Thanks in advance!

[Leith Ross]

Hello thecdnmole,

There are several ActiveX controls that are no longer supported in 64 bit only Windows. Unfortunately, there is not always a newer control to replace it or a work around available.

[thecdnmole]

Did this change just happen? As I said, everything was fine until just a few days ago.

[Leith Ross]

Hello thecdnmole,

No, it was several years ago. I would defragment the Registry on the offending computer and try it again.

[romperstomper]

What references do you have set in the workbook?

[thecdnmole]

Sorry romperstomper, I am quite new to this vba, what do you mean by "what references do I have set in the workbook"?

[romperstomper]

In the VB editor, with that workbook active, click Tools - References and see which items are checked.

Re the .exd files, how many did you delete?

[thecdnmole]

There were many .exd files I deleted, think about 30.
Excel_ref.png

[romperstomper]

Well the timing would certainly suggest the problem is the recent office updates - have you read the article linked to in my signature? (you'll have to check my first post to this thread to see my signature, due to a barmy decision by the powers that be)

[thecdnmole]

I was looking at it, but got busy with another item.

[thecdnmole]

When this error occurs, it brings up the vba code and highlights "option explicit" in blue. Does that mean something?

Also, my work laptop is NOT 64bit, it is only 32bit, but my home Office suite is "Professional" whereas the work one is "Standard". Hopefully that is not the reason that something I've used in vba only works in the PRO version of Excel?

[thecdnmole]

I have tried the "Fixits" to no avail. It looks like I do not have one of the latest updates, which is FM20.dll.

[romperstomper]

You must have fm20.dll or you could not use user forms or any MSForms controls on worksheets.

[thecdnmole]

Oh ya, it's there, just not the Nov. 19, 2014 version, it's from 2010. Just tried running same SS on my son's laptop which is running Office 2013 and it opens, but does not like "AppActivate" in the code! Gotta love computers!

[thecdnmole]

If you scroll to the bottom of the link provided, a comment is made by David Fabian suggesting that if the update was done on computer A, then you try and run software from A on B, it will not work if B has not been updated. I installed the update on B and deleted the .exd files, rebooted and back to normal!

http://excelmatters.com/2014/12/10/o...ivex-controls/

[romperstomper]

It's my site.