ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Help!! xlfGetDocuments returns invalid function error (xlretInvXlfn) (https://www.excelbanter.com/excel-programming/385377-help-xlfgetdocuments-returns-invalid-function-error-xlretinvxlfn.html)

nandan

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 ?



All times are GMT +1. The time now is 10:03 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com