Problem calling C++ DLL from Excel

[gvanto]

I am trying to access a c++ created DLL from within Excel, with semi-success only: I've followed the following tutorial EXACTLY: http://newtonexcelbach.wordpress.com...ng-excel-to-c/ Now, when I try and use the dll-functions that I've declared in the VB code, the function GetPrice(), which takes no arguments and simply returns a number, works fine. However, as soon as I create a dll-function which takes input arguments, I get a #VALUE error in the cell in Excel ("A value used in formula is of the wrong data type" ). I've downloaded the complete sample from the URL above and get the same error when running it (after recalculating the formulas). I've created a test 'proxy' function (in which the code can be stepped through, which calls the dll function) to ensure that values sent to the dll function are indeed of type double and that seems to be the case ... This guy seems to have had the same problem, however no solution was posted: http://www.ozgrid.com/forum/showthread.php?t=54245[^] Any help / tips would be greatly appreciated! g excell dll newbie

Find Your Dream Job in Australia, Free! http://www.WebCV.com.au