Solved

Microsoft Office Object Libraries for Multiple Versions of Excel

Posted on 2012-03-15
2
420 Views
Last Modified: 2012-03-23
Hi.  I need to develop a C# Excel add-in for multiple versions of Excel: Excel 2003, Excel 2007, and Excel 2010.  Do I need to change the referenced version of the Microsoft Office Object Library--11.0, 12.0, and 14.0--, recompile, and create a different installer for each version of Excel?  Hopefully, there is an easier way?  Thank you.
0
Comment
Question by:deatc
2 Comments
 
LVL 41

Accepted Solution

by:
dlmille earned 500 total points
ID: 37727186
You COULD do that.

However...........
You should find this post useful, and while it talks about office 2003 + 2007, I'm positive the concept extends to Office 2010.

It appears you can develop one version compatible with 2003, or you can develop the 3 projects then put the code in a shared assembly.

http://msdn.microsoft.com/en-us/library/bb772080(VS.90).aspx

Dave
0
 

Author Closing Comment

by:deatc
ID: 37758715
Thanks, Dave!
0

Featured Post

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
Performance in games development is paramount: every microsecond counts to be able to do everything in less than 33ms (aiming at 16ms). C# foreach statement is one of the worst performance killers, and here I explain why.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now