Excel - Problem running VBA Code

[Ecniv]

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

[nO_OnE]

That can depend on a lot of different things, such as the code.

Which version of Office 2010 are you running?
There is a 64 bit version of Office available, which can actually install both 64 bit and 32 bit versions. The 64 bit version requires some programming changes and can give you many issues when changing from older versions of Office.

[Ecniv]

Good question - no idea will check on monday - think its the 32 bit version

[Ecniv]

Haven't got access to the machines yet (people in meetings) however... Just thinking over it, how come if I log in as me on their machine it works, yet their log on it doesn't. Surely we'd all not be working... will post back once I have the version.

[VBFnewcomer]

Iam reminded of the days when my TV goes kaput..I call the mechanic...mysteriously the TV comes alive again, the moment he steps in!!! I serve him Tea & Biscuits and make him sit for half an hour still no issues. The mechanic bids goodbye, jumps onto his bike and vrrooms off...I come back into the house, only to find the TV has again blinked!!! erriee
So you are the mech in this case

[Ecniv]

Yeah - been getting that with systems here.. users having problems I wander in and watch them and it 'mysteriously' works again... I reckon they weren't doing it right, and when I turn up they are more dilligent lol


As to the Excel thing... its bugging me now :/

[nO_OnE]

Just thinking over it, how come if I log in as me on their machine it works, yet their log on it doesn't.

Not really sure, just guessing. On the one computer that I seen with Office 2010 64bit, it had both the 64 bit and the 32 bit versions. If that is the case, he could be opening the 64 bit version, and you may be opening the 32bit...

It is kind of odd that it highlights 'Option Explicit' during Debug, there may be something else wrong.

[Ecniv]

I think I wanna go with 'something else is wrong'

32bit version installed.


Wonder if it has lost the link to the right vba module... but then i log in would have thought it would play up on all.. :/


Might have another play today and see whether I can see anything that might be it.. a setting somewhere perhaps...

[Ecniv]

Oh... boy do things get weird.

I got one of the users who hasn't got a working version of the macros to log into the other machine.

It worked fine.



Suggests that there is a setting on the initial 2010 install or something on their account that is messing with it. Yet when they, as I did, log in to the other machine, it works.

A bit out of my comfortzone as to what is going wrong.


Does anyone happen to know of a way to reset the Excel to a default settings without un/re-installing?