Excel control from C++ app TedT 6/19/2007 5:36:06 PM Short version ... I need to control Excel spreadsheet values from my own C++ Windows app. Seems simple enough, conceptually ... find an SDK that can open a spreadsheet and support GetValue(), SetValue(), etc. Ideally, it would be Excel version-independent. I'm just not seeing any approach that I can pull the trigger on. Most posts I run into actually sound like they're adding functionality INSIDE of Excel. I can't tell for sure. The predominance of VB isn't helping me, either, as I just had one of those 'decade' birthdays and am realizing that I'm quite comfortable with VS6 and C++. So, please ... can anyone simplify this for me? Thanks in advance.

Re: Excel control from C++ app "Alexander Wolff" <ooops[ at ]gmx.de> 6/24/2007 10:42:44 AM [Quoted Text] > SDK that can open a spreadsheet and support GetValue(), SetValue(), > etc. Ideally, it would be Excel version-independent. GetValue(): I guess this can be realized, if you understand the formats (BIFF or zipped XML). SetValue(): is probably impossible outside a calculation programm itself. You would have to invent the wheel again - or have a very good understanding of the file formats. -- Moin+Gruss Alexander - MVP for MS Excel - www.xxcl.de - mso2000sp3 --7-2

Re: Excel control from C++ app TedT 6/25/2007 12:31:00 AM Thank you for your response. I've solved my problem by combining everything I'd run into, ignoring version discussions I'd believed, and ending up with a solution where my C++ app can create, modify, and read Excel spreadsheets. It was an adventure. I've tested successfully with versions 2000, 2002, and 2003 on XP. I haven't tested 2007, yet. I plan to make something available once my project is complete and I've more thoroughly wrung it out.