Excel VBA add-ins.add

[rmwitt]

to add a new add-in to the add-in menu (developer tab>add-ins), i execute the following:

Private Sub Workbook_Open()
Dim newAi As AddIn

Set newAi = Application.AddIns.Add(fileName:=ThisWorkbook.FullName, copyfile:=True)

this does not work for *.xlam files; however, this does work for *.xlsm files.

I have set trusted locations, and enabled the trust vba project check box.

has anyone experienced this? any solutions?

 

[rmwitt]

i am using excel 2019; windows 10

 

[rmwitt]

wow....after many hours of searching, i found the (a) answer. The reason why xlsm files work and xlam do not work, is because the xlsm file is open when the command, above, is executed. The xlam file is closed. To prove, try adding/installing the xlam manually, with no workbooks open...can't do it. So, there are two solutions:
1. open a blank (or any workbook), then execute 'set newAI = Application.AddIns.Add(fileName:=ThisWorkbook.FullName, copyfile:=True)' or better yet...
2. execute the line 'newAI.isaddin = false'. This will display the 'workbook page' associated with the addin. Then execute 'set newAI = ...' Depending on your application, you will only need to reset the flag 'newAI.isaddin = True', if you are still using the same addin for future use(rs) from which the code is executing. In my case, i copied the addin to another addin file, and the flag 'newAI.isaddin = True' is already set.

hopefully, my explanation makes sense; otherwise, please let me know.

voila!

thanks to Dr. K Solved: Can't get my XLA auto installer to work... [Archive] - VBA Express Forum

 

[RoryA]

Thanks for posting your solution.