EXCEL and MFC
-
I want to export data from a MFC program to EXCEL 97. The function prototypes are in excel8.h This is all part of excel8.olb. The only documentation I can find is for VB (vbaxl8.hlp on the MS Office distribution CD) WHERE CAN I FIND THE DOCUMENTATION FOR THE FUNCTIONS OF excel8.h (for C/C++ not VB) Anybody who knows COM, and OLE Automation should know... I am just a rookie when it comes to this part of programming Ethernal gratitude is guaranteed... Daniela
-
I want to export data from a MFC program to EXCEL 97. The function prototypes are in excel8.h This is all part of excel8.olb. The only documentation I can find is for VB (vbaxl8.hlp on the MS Office distribution CD) WHERE CAN I FIND THE DOCUMENTATION FOR THE FUNCTIONS OF excel8.h (for C/C++ not VB) Anybody who knows COM, and OLE Automation should know... I am just a rookie when it comes to this part of programming Ethernal gratitude is guaranteed... Daniela
I have to reply to my own post... There is NO documentation for EXCEL Automation for C++. It is extremely difficult using the VB documentation to get the C++ code right. For example range.PasteSpecial(Paste, Operation, SkipBlanks, Transpose) In VB, all 4 parameters are VARIANTS in the C prototype file excel8.h, the first two parameters are of type long. The "#define" for parameter Paste can nowhere be found I found a pathetic way to work around my problems. Just record a bunch of macros in EXCEL and call them from the C program myapp.Run( COleVariant("MyMacro"),...) //there are 30!!! optional parameters instead of the periods Daniela
-
I have to reply to my own post... There is NO documentation for EXCEL Automation for C++. It is extremely difficult using the VB documentation to get the C++ code right. For example range.PasteSpecial(Paste, Operation, SkipBlanks, Transpose) In VB, all 4 parameters are VARIANTS in the C prototype file excel8.h, the first two parameters are of type long. The "#define" for parameter Paste can nowhere be found I found a pathetic way to work around my problems. Just record a bunch of macros in EXCEL and call them from the C program myapp.Run( COleVariant("MyMacro"),...) //there are 30!!! optional parameters instead of the periods Daniela