|
PureBytes Links
Trading Reference Links
|
This came through on the Excel-L list and should answer the question that
you asked earlier.
The calls from VBA are shown on the very bottom of the last page listed
below.
"Dynamic Link Libraries in Excel/Visual Basic" e.g.,
"The visual basic code looks like this and makes the functions/subs
available in visual basic and Excel
Declare Function savitri Lib "c2vbtest.dll" (ByVal x As Double) As Double"
The microsoft article shows you what kind of animal you are dealing with. So
trying to find a specific "formula" to change in the dll may drive you nuts.
<G>
Best regards
Walter
=================================
The following may help - shows how to write dll's in Fortran & C/C++ and
call
from Excel VBA:
http://www.mathfinance.de/ - on the Left-hand menu click on "Front Office,"
then
"Excel/Visual Basic," finally "Dynamic Link Library usage in Microsoft
Excel/Visual Basic."
This is from MSDN, more general information:
http://msdn.microsoft.com/library/default.asp?URL=/library/techart/msdn_intr
o.htm
|