That is what I need, but I need the actual string, not aa version I can
reconstruct. The difference is that I need to know whether a single
cell was entered as "$B$1" or as "B1:B1" which are equivalent once the
become passed in as XLOPERS so I need to get the actual string from the
cell.
thanks!

Rob Bovey wrote:

"Matthew Wieder" wrote in message
...

How would I write the C++ XLL call that would take an XLOPER (of a
function) and get the string in that cell (i.e. the "=ThisFunc($A$3,
$F$7)") not the value that is returned by that function that is
displayed in the cell.


Hi Matthew,

I'm not sure I follow what you're asking for. Do you mean that if you
have the following function defined in your XLL:

EXPORT XLOPER MyFunc(XLOPER arg);

That you want a char* that looks something like "=MyFunc(A1)"?

That would seem to be self-evident. You know you have an equals sign
followed by the function name and a set of parenthesis containing a
comma-delimited list of the range addresses of the XLOPER arguments.