Hey all, first post.
i am automating Excel for a C# application, and i need to have some measure of backwards compatibility. Our old version supported back to 2000, but it was in C++ and doesn't come with the complexities that .NET Interop poses.
Couple of questions:
1. i could be crazy, but i'm fairly confident the version after 2000 was XP (2002).
2. What references do i need to add to my project to get things to work for both XP and 2003 (assuming XP is the 2002 version)? i've got:
Microsoft Excel 11.0 Library
Microsoft Excel 5.0 Library
3. What the heck is the 5.0 library?
Thanks for the help!