Automatic install of Add-in
 

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!

--
*********************
J Streger
MS Office Master 2000 ed.
MS Project White Belt 2003

Automatic install of Add-in
 

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.



---
Regards,
Norman



"J Streger" wrote in message
...
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!

--
*********************
J Streger
MS Office Master 2000 ed.
MS Project White Belt 2003