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

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


--
joel
------------------------------------------------------------------------
joel's Profile: http://www.thecodecage.com/forumz/member.php?u=229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=196233

http://www.thecodecage.com/forumz

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



--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Project Mangler" wrote:

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


.