loading automation add-in for an instance of Excel
 

An update:

I've found that uninstalling first helps:

AddIns("MyAddin.ForExample").Installed = False
AddIns("MyAddin.ForExample").Installed = True

This kick-starts it but I then find my UDFs don't recalculate, whether I use
Calculate, ActiveSheet.Calculate or Range(...).Calculate.

I can get a UDF to update if it's in a VBA wrapper:

Function vbaUDF(a, b, c)
vbaUDF = Application.Run("MyAddin.ForExample.dllUDF", a, b, c)
End Function

as I guess this has the effect of recalculating BUT I DON'T WANT TO DO THAT!

Any ideas out there??


"Smallweed" wrote:

I know that when you start an instance of Excel with VBA code, the add-ins
don't load which means you have to open or install them individually in the
code. For an XLA that's fine but I'm using an automation add-in (in version
2002). I've tried the following line:

AddIns("MyAddin.ForExample").Installed = True

but this doesn't do the trick. Does anyone know a way or will I have to go
the old-fashioned route and develop a VBA wrapper formy DLL?