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

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

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

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

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

Hi Uwe,

<<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

Under the Project/Settings/C/C++ menu make sure that the Debug Info
setting is Program Database and not Program Database for Edit and Continue.
The latter setting adds tokens to the debug code that cause Excel not to
recognize it.

<<and either Debug or Release of VC7.0 do not get recognized either

Same as above for the debug version, except the menu is Project/<Project
Name Properties/C/C++/General. Also make sure that the .def file has been
properly associated with the project. Under the menu Project/<Project Name
Properties/Linker/Input the .def file should be listed in the Module
Definition File setting.

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *


"um" wrote in message
.. .
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