Hi,

I'm getting the operation error message when running code that works fine in Excel 2003.

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

I have two users who are the advanced check / updated to 2010 and the VBA coding wont run on their machine/login.

Yet if I log in on their machine the code runs fine.

It looks like on their log ins that the Excel VBA has a problem. No idea why and I can't find anything useful online.

One post talked about a computer update from MS that may have corrupted part of the excel. Something to do with EXD but I cannot find any of those files.

I have checked the references listing - nothing is missing and when using debug compile it highlight "Option Explicit".

Very weird.

Has anyone come across this and how to fix it?

Other users on Excel 2003 are using and its running fine.
The main curious thing was when I log in its fine - just when they log in it isn't.

Anything to try will be helpful - not time pressing at the moment, but if they 'upgrade' everyone it will be a major headache.

Thanks in advance