C++ code

[Archie Duke]

Hello,
as a newbie I may be asking a stupid question already answered;
"how do I call a compiled C++ code that can be called from Excel
VBA ?"
il other words, how can I add a user written C++ coded function as a
referenced code in VBA ? "
Thanks all !

 

[SeanC UK]

Hi Archie,

Have a look for writing XLLs. There are several references to this subject
on MSDN, such as:
http://support.microsoft.com/default.aspx/kb/178474

There are also several books on this subject.

I hope this helps,

Sean.

PS this is something I've read up on, but not something I've had much
practice in, so I won't be able to help you much with anything more technical
than this on this subject, sorry.

 

[Archie Duke]

Hi Archie,

Have a look for writing XLLs. There are several references to this subject
on MSDN, such as:http://support.microsoft.com/default.aspx/kb/178474

There are also several books on this subject.

I hope this helps,

Sean.

PS this is something I've read up on, but not something I've had much
practice in, so I won't be able to help you much with anything more technical
than this on this subject, sorry.

Hi Sean,

many thanks. However what it leads to is :
* I have to go back to Excel 97
* I have to get MS' Developers' Kit in 97
I reckon my own researches have not led any further .

Thanks, it helps anyway.
Arch

 

[Chip Pearson]

If you are looking for a book regarding C/C++/XLL/Excel, you might be
interested in "Financial Applications Using Excel C/C++" and "Excel Add-In
Development In C/C++". I worked on a large project with the author of
these books. He is a very smart guy and writes quite well. Search Amazon for
"Steve Dalton" and you find his books.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel, 10 Years
Pearson Software Consulting
www.cpearson.com
(email on the web site)