Rob,

do you have anything else in terms of samples? When I compile the one from
Q152152, it will only get recognized by Excel, if I compile to Release of
VC6.0. The Debug version does not get recognized, and either Debug or
Release of VC7.0 do not get recognized either. Kinda hard to do, if you
can't use Debug code..

Thanks a mille,

Uwe



"um" wrote in message
...
Ok Rob,

it's article Q152152, found it.

Thanks again!

um


"um" wrote in message
...
Thank you Rob,

there seems to be a problem with the url you posted... "Q152/1/52.asp"
sounds wrong for a KB article ..??

Can you point me to the correct one?

Thanks again,

um


"Rob van Gelder" wrote in
message
...
Take a look at: support.microsoft.com/support/
kb/articles/Q152/1/52.asp


--
Rob van Gelder - http://www.vangelder.co.nz/excel


"um" wrote in message
...
Hello,

I am looking for a way to call a function from within Excel, like

@myfunc(B1:D10, E1)

which executes a C++-based function (potentially dll or COM) which
passes
the cell range i.e B1:D10, as well as the location where to store
the
result
of myfunc, i.e. E1. Subsequently the myfunc in the dll does it's
math
magic
and passes the result back to the spreadsheet into cell E1.

This can't be too difficult, except all the samples I see are VBA
based.
I
also downloaded the COMAddin sample which is C++-based, but I can't
seem
to
get the pointer to a range of cells which I marked prior to clicking
the
MyCommandBar button in the spreadsheet.

I have spent a lot of time in searches and I am getting frustrated
about
this.

Does anyone have a good pointer to a sample or a sample which I
could
dissect and use as a basis to start my project from? No VBA
please!!!

Thank you much in advance!

um