View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
stoney stoney is offline
external usenet poster
 
Posts: 3
Default VBA reference path goes to lower case

I developed an Excel application where the worksheets reference DLLs that I
wrote. It is several versions old, and all DLLs are compiled with binary
compatibility to the previous version. All DLLs have always worked on all
user machines.

Now, they still work on mine, but on user machines after the install of the
new version, the references dialog indicates that the DLL is missing. When
that is unchecked, closed, reopened, the DLL found & checked, the path is
lower case. When the file is saved, closed & reopened, the DLL shows again as
missing.

Just before this version was installed, all machines were upgraded to Office
2003 sp2 and to XP sp2. There's probably a catch here somewhere.

Any ideas?
Thanks in advance - Stoney