View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
nandan nandan is offline
external usenet poster
 
Posts: 11
Default Help!! xlfGetDocuments returns invalid function error (xlretInvXlfn)

Hi,
Someone please help..this is driving me crazy..and i am close to
release :-(.

I have an addin using the C++ XLW API...it also has a dotNET
component.

I make the following call. (I am trying to detect whether the user has
automatic calculation turned on)

XlfOper ret;
int success=0;
success = XlfExcel::Instance().Call(xlfGetDocument, ret, 1,
XlfOper((short)14));

This works fine with Excel 2003 and .NET 1.1
On a machine with Excel 2003 and .NET 2.0 this call often, but not
always returns
success = 2 (which means xlretInvXlfn - invalid function number).
Help what is going on????

When i actually print out the value of xlfGetdocument it is 188 -
which is correct.
Is my stack getting corrupt ?