I dont know if this is best as well but i use another excel workboo
with the code to install th addin from the folder where the program i
located. i put the code in the workbook open event along with code t
close th workbook.I use a bat file to delete it as well as delete th
batfile from the batfile itself
[Run]
Filename: "{app}\add addin.xls";Flags: shellexec
Filename: "{app}\Starting Files\code\MyDLL\regdll.bat"
batfile
del "add addin.xls"
del "Starting Files\code\MyDLL\regdll.bat"
del "Delete.bat"
hope this helps
code here
Private Sub Workbook_Open()
a = ThisWorkbook.Path
ChDir (a & "\Starting Files")
ChDir "code"
a = CurDir
AddIns.Add(a & "\ORL SCH v3.0.xla").Installed = True
AddIns.Add(a & "\ORLschDATA.xla").Installed = True
Application.Quit
End Su
--
rjtaylo
-----------------------------------------------------------------------
rjtaylor's Profile:
http://www.excelforum.com/member.php...nfo&userid=590
View this thread:
http://www.excelforum.com/showthread.php?threadid=26994