Click here to Skip to main content
15,922,696 members
Home / Discussions / C / C++ / MFC
   

C / C++ / MFC

 
GeneralRe: Cell change event in Excel Pin
NarVish21-Sep-09 20:31
NarVish21-Sep-09 20:31 
GeneralRe: Cell change event in Excel Pin
NarVish23-Sep-09 23:26
NarVish23-Sep-09 23:26 
GeneralRe: Cell change event in Excel Pin
Stuart Dootson24-Sep-09 5:57
professionalStuart Dootson24-Sep-09 5:57 
GeneralRe: Cell change event in Excel Pin
NarVish24-Sep-09 19:32
NarVish24-Sep-09 19:32 
GeneralRe: Cell change event in Excel Pin
Stuart Dootson24-Sep-09 20:11
professionalStuart Dootson24-Sep-09 20:11 
GeneralRe: Cell change event in Excel Pin
NarVish24-Sep-09 21:26
NarVish24-Sep-09 21:26 
GeneralRe: Cell change event in Excel Pin
Stuart Dootson25-Sep-09 4:03
professionalStuart Dootson25-Sep-09 4:03 
GeneralRe: Cell change event in Excel Pin
NarVish29-Sep-09 19:45
NarVish29-Sep-09 19:45 
Thank you for your post.
SheetCalculate is getting fired whenever there is change in function related cells. My aim is to get the function result in excel. To get that I'm trying by calling different functions of iDispatch. But couldn't able to get the expected result.

void _stdcall SheetCalculate(IDispatch *iDispatch)
{
////////////*******GetIDsOfNames*******////////////
static DISPID dispid = 0;
wchar_t *ucName = L"Evaluate"; //I tried by giving "Run" and "Calculate" values in place of "Evaluate"
HRESULT result = iDispatch->GetIDsOfNames(IID_NULL, &ucName, 1,LOCALE_SYSTEM_DEFAULT, &dispid);

////////////*******Invoke*******////////////
VARIANT varResult;
DISPID dispid;
DISPID dispidNamed = DISPATCH_METHOD;
EXCEPINFO excep;
UINT uArgErr;
DISPPARAMS dispparams;
dispparams.cNamedArgs = 0;
dispparams.cArgs = 2;
dispparams.rgdispidNamedArgs = &dispidNamed;
HRESULT result = iDispatch->Invoke( odispid, IID_NULL, LOCALE_SYSTEM_DEFAULT,
DISPATCH_METHOD, &dispparams, &varResult, &excep, &uArgErr);

////////////*******GetTypeInfo*******////////////
ITypeInfo* pTypeInfo;
HRESULT result= iDispatch->GetTypeInfo(0,LOCALE_SYSTEM_DEFAULT,&pTypeInfo);

////////////*******GetTypeInfoCount*******////////////
UINT pct1;
HRESULT result= iDispatch->GetTypeInfoCount(&pct1);

////////////*******QueryInterface*******////////////
HRESULT result = iDispatch->QueryInterface(IID_IDispatch,(void**)&iDispatch);
}
I followed the below link to get some help.
"http://up.m-e-c.biz/up/books/Excel%20add-in%20C++.pdf"
GeneralRe: Cell change event in Excel Pin
NarVish30-Sep-09 18:29
NarVish30-Sep-09 18:29 
GeneralRe: Cell change event in Excel Pin
NarVish15-Oct-09 1:38
NarVish15-Oct-09 1:38 
GeneralRe: Cell change event in Excel Pin
Stuart Dootson15-Oct-09 2:26
professionalStuart Dootson15-Oct-09 2:26 
GeneralRe: Cell change event in Excel Pin
NarVish15-Oct-09 2:43
NarVish15-Oct-09 2:43 
GeneralRe: Cell change event in Excel Pin
NarVish15-Oct-09 19:29
NarVish15-Oct-09 19:29 
GeneralRe: Cell change event in Excel Pin
NarVish18-Oct-09 22:13
NarVish18-Oct-09 22:13 
GeneralRe: Cell change event in Excel Pin
Stuart Dootson19-Oct-09 0:25
professionalStuart Dootson19-Oct-09 0:25 
GeneralRe: Cell change event in Excel Pin
NarVish19-Oct-09 0:54
NarVish19-Oct-09 0:54 
GeneralRe: Cell change event in Excel Pin
Stuart Dootson19-Oct-09 1:09
professionalStuart Dootson19-Oct-09 1:09 
Questioninterfacing google earth with c++/MFC app Pin
brian scott21-Sep-09 0:20
brian scott21-Sep-09 0:20 
QuestionWriting unicode to file Pin
yeah100021-Sep-09 0:12
yeah100021-Sep-09 0:12 
AnswerRe: Writing unicode to file Pin
Nuri Ismail21-Sep-09 0:19
Nuri Ismail21-Sep-09 0:19 
GeneralRe: Writing unicode to file Pin
yeah100021-Sep-09 0:42
yeah100021-Sep-09 0:42 
AnswerRe: Writing unicode to file Pin
Naveen21-Sep-09 1:12
Naveen21-Sep-09 1:12 
GeneralRe: Writing unicode to file Pin
yeah100021-Sep-09 1:56
yeah100021-Sep-09 1:56 
GeneralRe: Writing unicode to file Pin
Naveen21-Sep-09 2:27
Naveen21-Sep-09 2:27 
AnswerRe: Writing unicode to file Pin
David Crow21-Sep-09 2:15
David Crow21-Sep-09 2:15 

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.