VBA Argument pass to DLL Issue

[DougD720]

Hello,

So I'm completely new to VBA and I've written a DLL to do some functions and the idea is to pass the results back to Excel. The DLL works fine, I've tested it extensively. The issue is the last argument I pass to it from VBA in Excel, no matter what value it is, always gets passed as the same, very large number. Below is the VBA code and then the DLL function declaration. Help would be greatly appreciated I have no clue what's going on here. The last two arguments are to be passed as number values, both are passed in the same way, and the first works, the second doesn't.

VBA Code:

Please Login or Register  to view this content.

And here's the function definition from the .h file for the DLL:

Please Login or Register  to view this content.

Thanks!

[Norie]

Have you checked what the value is in C2 on the sheet 'LMM'?

[DougD720]

Yes, I can MsgBox(np) and it gives the correct value, but when I'm debugging and check the value once it's passed into the DLL it's completely different. What's weird is if I switch the ordering - pass in the np where the sz is and vice-versa, then the np is passed in fine but the sz is that same large number, which is really baffling.

[DougD720]

Here's what's really weird. I tacked on another variable for the DLL function as a test/dummy variable. Then I pass np in both, in the first pass it gives the same large value - in the second the correct value. For some reason there's something off with the 6th argument, just that one.

[JosephP]

can you register the .dll and set a reference to it and then call it without the declare? does it work then?

[DougD720]

Well the DLL isn't designed to be registered / doesn't have the proper register/unregister functions but I can try. In the meantime does anyone else have any ideas?