Trying to load C# AddIn into Excel.

Question

I am trying to load C# AddIn into Excel.  I followed the steps here:

https://www.quantnet.com/forum/threads/how-to-create-udf-in-excel-using-c-and-visual-studio-2008.1260/

 

AFAIK, I did everything exactly like the author described it.  I built the BlackScholesAddIn and it seemed to work fine (I got no errors).  However, I can’t seem to find the AddIn anywhere when I open Excel.  How can I load this AddIn?  I’m getting no error messages; nothing whatsoever.

 

I am using VS 2010 and Excel 2010.

As you can see, it doesn't show up automatically, and when I try to 'Browse' to it, I can't see any files inside the solution (all folders seem to be empty), so I can't run it from there either.

Any ideas, anyone??

Answer 1

Do take a look at this. There is part of it show how to you do udf.

http://exceldna.codeplex.com/

chanmm

---

chanmm

Answer 2

Oh.  I figured it out.  I didn't read the instructions carefully; missed a step before.

Everything fine now!!

Answer 3

Hi ryguy,

Welcome to the MSDN forum!

It seems that you have solved the issue. Based on my experience, you seemed to have missed to browser the Automation Server in the Automation Servers dialog.

Below are the steps to load the managed automation add-in into Excel after the add-in is built and registered:

1. Launch Excel, and click the Microsoft Office button in the top-left corner of the window.

2.Choose Excel Options.

3. Click the Add-Ins tab in the Excel Options dialog box.

4. Choose Excel Add- Ins from the combo box labeled Manage, and click the Go buttton.

5. Click the Automation button in the Add-Ins dialog box.

6. Look throught the list of Automation Servers, and find the class you created.

Meanwhile, if you have questions about Excel development, you may as well try the Excel for Developers Forum: http://social.msdn.microsoft.com/Forums/is/exceldev/threads

Have a nice day!

yoyo

---

Yoyo Jiang[MSFT]
MSDN Community Support | Feedback to us