"mrvgson" wrote in message
...
Q from Excel novice

1. I created an Excel Addin (myUDF.xla) that contains my user defined
functions
and saved it in the "...Application Data\Microsoft\Excel\XLSTART"
folder so that it is automatically loaded everytime I launch Excel.

2. I then launched Excel. (it opens Book1.xls)

3. I click the "Paste Function fx" function and browse to see what User
defined functions are available.
The functions the I added in myUDF.xla show up on the list. Great...

However, when I launch Excel through automation, and then open a workbook,
and repeat step 3
my user defined functions are no longer on the list.

Please note: My addin"myUDF" is never listed in the Add-ins available even
in 2 when I launch Excel directly without automation. However, the
functions
are made available in this case.

Has anyone encountered this problem when invoking Excel through
automation?
How can I resolve this? Your help is greatly appreciated.

Thanks,
Siva


This is how Excel works. It won't load add-ins when Excel is started as an
automation object. Behavior by design.

/Fredrik