Click here to Skip to main content
15,905,590 members
Home / Discussions / C / C++ / MFC
   

C / C++ / MFC

 
GeneralRe: use ShellExecute ? Pin
_skidrow_vn_7-May-03 9:39
_skidrow_vn_7-May-03 9:39 
GeneralRe: use ShellExecute ? Pin
_skidrow_vn_7-May-03 9:46
_skidrow_vn_7-May-03 9:46 
GeneralCArchiveException Pin
Shay Harel7-May-03 8:46
Shay Harel7-May-03 8:46 
GeneralRe: CArchiveException Pin
David Crow7-May-03 8:54
David Crow7-May-03 8:54 
GeneralRe: CArchiveException Pin
Anonymous7-May-03 8:59
Anonymous7-May-03 8:59 
GeneralRe: CArchiveException Pin
basementman7-May-03 10:55
basementman7-May-03 10:55 
GeneralAdding Controls Dynamically to CFormView Pin
Muhammad Yousaf7-May-03 8:43
Muhammad Yousaf7-May-03 8:43 
GeneralCOM Pin
Heiko20037-May-03 8:08
sussHeiko20037-May-03 8:08 
Hi,
I write into Excel over COM
My Problem is the interface IDispatch. I can't get acces to a SeriesCollection object with this interface.
I've tried to map anotherone but this doesn't works. The compiler says the code is ok but when executing i got an invalid pointer massage

Here are some parts of my code:

_ApplicationPtr pXL;
pXL.CreateInstance(L"Excel.Application.9");
.
.
.
pXL->Range["Messwerte!B5"]->Value2= 35.6;
pXL->Range["Messwerte!B6"]->Value2= 32.7;
pXL->Range["Messwerte!B7"]->Value2= 33.6;
pXL->Range["Messwerte!B8"]->Value2= 37.6;
pXL->Range["Messwerte!B9"]->Value2= 34.6;

pXL->Charts->Add();
pXL->ActiveChart->SetSourceData(pXL->Range["Messwerte!B5:Messwerte!B9"], _variant_t((long)xlColumns) );
pXL->ActiveChart->ChartType = xlLineMarkers;
pXL->ActiveChart->Location(xlLocationAsObject,"Messwerte");
pSheet->Shapes->Item( _variant_t((long)1) )->Top = 0;
pSheet->Shapes->Item( _variant_t((long)1) )->Left = 0;
pSheet->Shapes->Item( _variant_t((long)1) )->Width = 400;
pSheet->Shapes->Item( _variant_t((long)1) )->Height = 200;
// it works until here now i want change some attributes of the chart so i have to use an SeriesCollection Object

IID IID_ISERIESCOLLECTION = {0x00020813-0x0000-0x0000-0xC000
0x000000000046};
ISeriesCollection *pscMyCollection;
pXL->ActiveChart->SeriesCollection( _variant_t((long)1) )->QueryInterface(IID_ISERIESCOLLECTION, (void**)&pscMyCollection);

pscMyCollection-> //here i want to acces members, e.g. Item, Add.. but it doesn't work

Thanks for Help


GeneralRe: COM Pin
Heiko20037-May-03 11:34
sussHeiko20037-May-03 11:34 
GeneralCreating multiple buttons with one resource Pin
jimNLX7-May-03 7:45
jimNLX7-May-03 7:45 
Generaldll memory and shared segment question Pin
keyser_soze7-May-03 7:41
keyser_soze7-May-03 7:41 
GeneralIs it possible to have one button do the function of two buttons in MFC. Pin
Anonymous7-May-03 7:29
Anonymous7-May-03 7:29 
GeneralRe: Is it possible to have one button do the function of two buttons in MFC. Pin
User 66587-May-03 7:50
User 66587-May-03 7:50 
GeneralRe: Is it possible to have one button do the function of two buttons in MFC. Pin
Maximilien7-May-03 7:50
Maximilien7-May-03 7:50 
GeneralRe: Is it possible to have one button do the function of two buttons in MFC. Pin
jimNLX7-May-03 7:51
jimNLX7-May-03 7:51 
GeneralRe: Is it possible to have one button do the function of two buttons in MFC. Pin
Nick Parker7-May-03 7:56
protectorNick Parker7-May-03 7:56 
Generalfstream question Pin
Shah Shehpori7-May-03 7:15
sussShah Shehpori7-May-03 7:15 
GeneralRe: fstream question Pin
Nathan Blomquist7-May-03 7:23
Nathan Blomquist7-May-03 7:23 
GeneralRe: fstream question Pin
Nick Parker7-May-03 7:44
protectorNick Parker7-May-03 7:44 
GeneralCHeaderCtrl, 2 Problems Pin
schoni7-May-03 7:09
schoni7-May-03 7:09 
GeneralRe: CHeaderCtrl, 2 Problems Pin
David Crow7-May-03 8:01
David Crow7-May-03 8:01 
GeneralCHeaderCtrl Pin
schoni7-May-03 7:08
schoni7-May-03 7:08 
GeneralRe: CHeaderCtrl Pin
Roger Allen8-May-03 1:26
Roger Allen8-May-03 1:26 
GeneralAccessing a Sybase Stored Procedure Pin
Unplugged7-May-03 5:37
Unplugged7-May-03 5:37 
GeneralRe: Accessing a Sybase Stored Procedure Pin
jmkhael7-May-03 6:11
jmkhael7-May-03 6:11 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.