Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

problem in function xlcWorkbookSelect

24 views
Skip to first unread message

sunil adhyaru

unread,
May 31, 2010, 9:04:33 AM5/31/10
to
Hi All,

I am using function excel sdk 2007 function "xlcWorkbookSelect" to
move to another sheet.

But it is not returning response zero which is for success and I am
not able to move to another sheet.

Following is code which i am using.

LPXLOPER12 xlFileOpenSheet;
xlFileOpenSheet = (LPXLOPER12) malloc(sizeof(XLOPER12));
xlFileOpenSheet->val.str = (WCHAR*)malloc(sizeof(WCHAR)*255);
xlFileOpenSheet->xltype = xltypeStr;

swprintf(xlFileOpenSheet->val.str,(WCHAR *)" %s",tempNode->m_cellinfo-
>strWorkSheetName);
xlFileOpenSheet->val.str[0] = wcslen(xlFileOpenSheet-
>val.str );

int fx = Excel12f(xlcEcho,0,1,&xlcCommandSetBoolValue);
fx = Excel12f(xlcWorkbookSelect,0,1,xlFileOpenSheet);
fx = Excel12f(xlFree,0,1,xlFileOpenSheet);

sunil adhyaru

unread,
Jun 1, 2010, 5:48:50 AM6/1/10
to
I am getting response "xlRetFailure" when calling function
"xlcWorkbookSelect"
0 new messages