VBA Reference Issue

[xJimba1]

Hello,

I am having an issue on 1 XP machine running a server version of an Excel VBA program. Whenever this file opens on 1 specific computer, the reference to another CodeLibrary.xls is flagged as MISSING although it is in the proper location.

If I try to repoint the reference again to the same location, it doesn't show a failure window, but stays as missing. If I navigate the Reference to the same folder in another path, it seems to work fine, but I can't really change that reference in the production version. Multiple users access this file without issue. Both the Excel file and the referenced Excel file are on he same network share.

Is there something on this specific pc that I should be looking at because I'm pulling my hair out over here.

Thanks in advance

 

[bensonsearch]

Hi,
have you checked under the vba editor if the referance is added? ticked?

otherwise maybe some kind of security issue with the file and the particular user ID?

 

[xJimba1]

Thanks for the reply. Yes it is checked, but still remained as missing even after a pointed it to a known good file.

To fix the issue I actually deleted the Excel key from the reg and let the program re-create it. Seemed to work so far.