Missing References

[Project Mangler]

I had a problem today with a missing reference - Microsoft Forms 2 on a
colleague's machine at work (Office 2003; VBA 6.5; XP).

I've read Chip Pearson's "Missing References in VBA" which is a geat
explanation about how to fix problems like this.

Oddly the library didn't seem to be flagged as "missing" and was in fact
present in the system32 directory but didn't show up in the list of
available references.

Now to the questions:

I'm not clear on whether if I write code in a project that references a
library which is not part of the "core libraries" the additional reference
*should* be loaded transparently by Excel (accepting that sometimes that
process can fail).

Is it likely that the reason that Forms 2 dll didn't load was that it wasn't
shown in the References list although the library was actually available in
the system32 directory?

I hope this makes sense.

DB

 

[joel]

I've seen missing references occur often. Usually I've seeen th
problem when office gets updated and the update software doesn't mov
the refernce from the older version of Office (in program files) to th
newer version of office. but it sometimes happens in windows system3
folder. the version of the dll is part of the name of the dll and whe
updates are performed sometimes the update software misses a DLL. I'v
also seen PC's where DL's got accidently dleeted and simply copying th
dll from another PC fixes the problem.

 

[ryguy7272]

Weird. Maybe turn it off, wait a couple minutes, turn it on, and try it
again. Maybe a memory issue...