Corrupted libraries of Office installation?

[TommyIndigo]

I have an Excel workbook with quite a bit of code throughout. It uses the VBA, Excel, and MS Forms libraries.

It works fine for 10 of 12 users. The two problem users get errors as though their libraries aren't installed. Simple functions like Space() are erroring out for them.

I checked their References, and the correct libraries are checked (and not 'MISSING').

I browsed the forum, and saw unregistering/reregistering the library .dlls using Regsvr helped some people. It didn't work in this case.

I assume my code is fine, as most users have no issues whatsoever. Is a reinstall of Office warranted??

I have users on both 2003 and 2007. The problem users both have 2003, but other 2003 users are fine.

Any ideas would be most appreciated!

 

[TommyIndigo]

Just wanted to bump up this post. I'm rather desperate. Any ideas?

 

[SkipVought]

Have you tried Help > Detect & Repair...?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[TonyJollans]

I checked their References, and the correct libraries are checked (and not 'MISSING').

What about other libraries - any MISSING ones can cause problems of the type you describe with VBA functions.

If all are present, try removing all the optional ones (the ones it will let you uncheck) on a problem machine. If the problem goes away, try replacing them one at a time to find the problem one. This may not be as easy as I make it sound as removing references may introduce other errors and some trial and error and judicious commenting may be required.

Enjoy,
Tony

------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.

I'm working (slowly) on my own website