View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
rjtaylor[_16_] rjtaylor[_16_] is offline
external usenet poster
 
Posts: 1
Default add-in installation Inno setup file


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