raheelasadkhan
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?
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?
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.
I know it is a pain, but the com-realated PIAs are to blame.
ASKER
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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