Ken Vogel
Posts: 1
Joined: 2009-01-28
|
I've discovered CallWorksheetFunction by looking at other forum posts here. This appears to be a wrapper on Excel4/Excel12, which is very useful. However, I can't find any mention of CallWorksheetFunction in the documentation (in fact, ADXXLLModule isn't even listed in the API docs). Is this function described anywhere?
This function uses the (misspelled) enum ADXExcelWorkseetFunction to map to the various xlf* constants defined in the XLL API. The int values of these enums appear to be exactly the xfl constants from xllcall.h
However, I couldn't find an enum for xlfSetName (enum value 88). Was leaving this out a just a mistake, or is there something about this that doesn't work? The following code does appear to work for me, but I'm worried that I'm doing something that is unsupported.
Module.CallWorksheetFunction((ADXExcelWorkseetFunction)88, MyWSName", myref);
Thanks in advance,
Ken |
|
Andrei Smolin
Add-in Express team
Posts: 18825
Joined: 2006-05-11
|
Hello Ken,
Thank you for pointing us to the whole bunch of our problems. Now we will think on how to fix this.
I've checked the implementation of CallWorksheetFunction; your code should work without any problems. |
|