View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
J Streger J Streger is offline
external usenet poster
 
Posts: 101
Default 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