Automatic install of Add-in

[Guest]

I ahve been trying to get the correct code for automatic installation of an
add-in. I cannot use 3rd party software so I have to write it myself. I am
basically going to tell my users to put the file in their C drive and click
on the .xla I keep having the 'unable to set add property of addins' error
for the following code

Dim aiUseful As AddIn

Set aiUseful = AddIns.Add("c:\Useful Tools.xla")
aiUseful.Installed = True

I checked spelling and made sure I could install this manually, so any ideas
why it won't let me add this programatically to the add-in list?

Also I could not get an excel file to save as an .xla file that excel would
then recognize. Any help with that? Thanks all!

 

[Norman Jones]

Hi J,

I would suggest that you look at Jan Karel Pierterse's excellent Addin
tutorial at:
http://www.jkp-ads.com/Articles/DistributeMacro00.htm

Jan Karel includes a setup utility.