I'm having an issue with an add in file (.xlam) that excel seems unable to find. I have an add-in in a file "C:\my_add_in_dir\my_add_in.xlam" which I have installed on several different machines in the same location. I have a workbook, which on workbook open calls "Addins.Add("C:\my_add_in_dir\my_add_in.xlam")" This code runs fine and when I open up File->Options->Add-Ins I see the add-in under Active Application Add-Ins in the correct file location. The problem occurs when I try to make a call to Application.Run("my_add_in.xlam!Some_Macro"), I get a run time error 1004 saying "Sorry we couldn't find C:\Users\user_name\Documents\my_add_in.xlam". It seems as if somehow excel thinks this add-in is located in a completely different file location. Also this error only occurs on one of the several machines that I have this add-in installed in.

I have tried the usual fix of removing the add-in file from its directory, opening excel, deleting it from the add-in dialog box, then re-adding it. Unfortunately this doesn't solve the issue.

If anyone has any guidance it would be greatly appreciated.

Thanks