Link to home
Start Free TrialLog in
Avatar of raheelasadkhan
raheelasadkhanFlag for Pakistan

asked on

How to create an Excel add-in from C# Express?

I need to create an Excel add-in using Microsoft Visual C# 2008 Express edition. How can I target Excel 2003 and 2007 using this approach?
Avatar of Miguel Oz
Miguel Oz
Flag of Australia image

you can use shared add-in:  (com add-in)
http://www.add-in-express.com/add-in-net/com-addins.php
http://msdn.microsoft.com/en-us/library/aa296294(office.11).aspx

http://support.microsoft.com/kb/302896
http://msdn.microsoft.com/en-us/library/bb508939.aspx

You need to create one shared add-in for 2003 and another one for 2007, because the com interface of Excel 2003 is different from Excel 2007
Avatar of raheelasadkhan

ASKER

So far I've only come to the conclusion that I need to create two separate VS projects. One on a machine with 2003 installed and another with 2007 installed. Is this normal?

In any case, will I still require the PIAs to be installed on the target systems in the case of add-ins?
The answer is Yes for both questions.
I know it is a pain, but the com-realated PIAs are to blame.
Thanks. Crap! now I'll have to find a way to install the PIA's from within my setup. I somehow know this is going to have it's complications. Thank you Microsoft!
ASKER CERTIFIED SOLUTION
Avatar of Miguel Oz
Miguel Oz
Flag of Australia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial