I need to automate Excel from C++ code. I'm currently using the #import statement on excel8.dll to get an interface created.
This works fairly well but it is a pain to find any information on the Excel object structure. Just finding out what object(s) you need to access for the information or functionality you need can be a real detective work. I've not found any books or other good material touching on this subject.
Anyone here familiar with this and can recommend some reading for me?