Hello,



I am adding an AddIn through VBA in the follow manner:

Code:

 
 
sDirectory = "C:\directory\"
    sFilePath = sDirectory & "AddInFile.dot"
AddIns.Add FileName:=sFilePath, Install:=True

This works for most of my users, but a couple have had a problem with Word not being able to locate the file resulting in an error. The interesting part is that it worked for these users for 6 to 8 weeks and then stopped working.

Additionally, if I rename the file and change the file path in the VBA, Word then can find the file. I have googled this one for about a week with no luck. If I run the following code:

VBA says the file is there.

Also, another user can log into the specific machine and the application works as expected, so the issue seems to be confined to the users specific Word files under their account. One user reimaged their machine and the problem went away but this is not a valid solution for obvious reasons.

Is there a cache in word (other than recent files, recent places) that can be cleared to help Word find the file or some solution to this particular issue?

Thanks in advance for any help.

Since you've identified an issue with the user profiles, it is unlikely changing anything in the code or even an Office setting would resolve it. That said, you might try repairing the Office installation (via Start > Windows Control Panel > Programs > Programs & Features > Microsoft Office (version) > Change>Repair).

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Thank you Macropod for your reply. Unfortunately the solution you suggested did not fix the problem. What did fix the issue was opening a blank word document and then via the Word's own Add-In functionality add the document. Close the blank document and then run the vba code. This works even after completely closing word, the user logging out and even after a reboot. File => Options => Add-Ins => Word Add-Ins (From Drop Down Menu) => Add Button on Popup dialog.