Excel trying to use wrong file location for custom add in

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

Perhaps
https://answers.microsoft.com/en-us/...5-722d7ebe4a67
Alf

@Alf, thanks for the link, this particular add-in in question doesn't use a toolbar. The error comes from calling an addin function inside VBA, it's almost like Excel (or VBA) doesn't know where the addin file is located even though its been properly installed. The error message I get says that it is looking for the addin file in "C:\Users\user_name\Documents\" which happens to be the default file location from the settings in File-> Options -> Save.

Try going to your add-in in your documents folder and right click on the add-in. Then click on properties, and see if you have a box you can check that says unblock. Click in the checkbox to unblock the add-in. This is what I had to do with my add-ins after MS made a security change in July 2016.

@XL&ME, thanks for the tip. I did have a box that said "Unblock" in the file properties window, I clicked it and it didn't change the status of the error message though. When you were experiencing this issue did it occur each time a call was made to the add-in or was the error more sporadic? I'm able to put a temporary fix on the issue by re-ticking the add-in from the add-in dialog box, but in a week or two the error will resurface.

Thanks

When I clicked on Unblock, I then closed the window and ran the add-in. Haven't had to Unblock the add-in once I did it the first time, unless I had to re-install a add-in for some reason.

Originally Posted by XL&ME

When I clicked on Unblock, I then closed the window and ran the add-in. Haven't had to Unblock the add-in once I did it the first time, unless I had to re-install a add-in for some reason.

Initially when you were getting the error, before implementing the unblock fix, was the error consistently occuring or did it only pop up occasionally?

The error occurred continuously until I was able to successfully Unblocked the add-in. Had one add-in that I installed and uninstalled many times and tried various things before I could get it to work properly. In the end, after installing and uninstalling it still took several time to successfully Unblock the add-in.