I am trying to store code in a second file to keep file bloat down. I have
created a file called ia.xla in which I have stored many code snippets used
across hundreds of file.

I would like ia.xla to start when a second workbook is opened. I have tried
the following code but cant seem to get it to work.

Set objTemp = Application.AddIns.Add( €œC:\temp\ia.xla€�, False)

Also note: I cant change the install on the machines so I cant put the
file in a xl startup file. I must start xla file when the calling xl
workbook opens. I would also like to hide the workbook on open.

The only way I can launch the addin file is to call a procedure from the file:

Application.Run " C:\temp\ia.xla!IAGeneral.hello" but this does not hide
the workbook

Any thoughts would be appreciated.

Regards,

Stewart Rogers