calling function from C++ dll

[kgarrett]

I have written a function in a C++ dll and I am trying to call it from VBA for Excel. I get the #value! error in Excel. I have read tutorials, talked to people, etc. I cannot see what the problem is. It really isn't a complicated function. Please provide possible solutions.


Kgarrett

 

[nickjar2]

I haven't used C++ dlls but maybe trying (in a code window) tools references and locating your dll. That way excel will have a reference to it.

Nick

 

[kgarrett]

Thanks. I tried that, but it said "can't add that file".
I have used the

Public Declare Function .... Lib "....\.dll"

line in VB. This should connect to the .dll. I am at a loss. Any other ideas??



Kgarrett

 

[nickjar2]

I am not too sure. I recently downloaded a ocx from the net and had to register it before I could use it (regsvr32.exe). But apart from that I cannot think of anything else. Sorry.

Nick