Very strange VBA problem

[Jim Bassett]

This one is a strange problem. To begin with we have developed many Excel templates( Excel 2000 with the latest service packs) with VBA modules and one of those modules is a VB class that uses mid$. These templates all work find on Win 2000, Win XP, Win 98, Office 2000 and Office 2002 except on this one persons PC which is an Office 2000( latst service packs) and Win 2000 with latest service packs. On this person PC we get an error message that the library for Mid$ cannot be found. Now what makes this even stranger is that on this very same PC if we create a new Excel template and make use of Mid$ it is found with no problem. We also have re-installed Office and still this is happening. Anyone have any idea what is hapening?

[si_the_geek]

Yep - it's a common issue that has absolutely nothing to do with Mid$...

If you look in VBA under "Tools"-"References", you'll see that something is listed as "Missing: ...". You need to find the file that this refers to (maybe copy it from another computer), then use "Browse" to select it.

Once that is done, you won't get the strange message again

[Jim Bassett]

Thanks. Yea that is what we first suspected but there are no references missing. I told you this is a strange problem!

[Red51]

It may be an older version than the one that is needed then. So it finds it, it's registered, but when it goes to use it a method or property may be missing.
Try copying all the needed files from a good machine. If you've reinstalled Office, I'd start with in-house ones and other non-Office files

[Matt_T_hat]

Sounds like a registory problem. I would go get "Norton SystemWorks 2003" and run WinDoctor (from CD) or some other non-microsoft registory integrity checker. si_the_geek is correct about the problem being other than what it says it is simply windows hast lost track of what's what. Ultamatly it's information stored in the registory.

If confident try RegEdit. but for goodness sack back up the damn registors first. you can do a lot of harm in there.