Hi excel Gurus
hopefully one of you guys can help me and my friend.
I have written dll in C++ and using it in excel on my computer NO problem at ALL
I followed this tutorial A function defined in C++ and passed on to Excel : a DLL example | Quant Corner
when I gave the DLL to my friend and set up "Declare Function" on his PC same exact way quadruple checked syntax word for word. Dll is in the same location on his pc everything is the same.
He get #Value!
we then wrote subroutine to call function from and put in err.Debug msgbox we see that the error it gives us is the DLL not found....
We really dont understand what is going on... Tired for hours searching google with no help.
Can someone suggest what we may be doing wrong or what we should try?
Thank you very very much in advance
hopefully one of you guys can help me and my friend.
I have written dll in C++ and using it in excel on my computer NO problem at ALL
I followed this tutorial A function defined in C++ and passed on to Excel : a DLL example | Quant Corner
when I gave the DLL to my friend and set up "Declare Function" on his PC same exact way quadruple checked syntax word for word. Dll is in the same location on his pc everything is the same.
He get #Value!
we then wrote subroutine to call function from and put in err.Debug msgbox we see that the error it gives us is the DLL not found....
We really dont understand what is going on... Tired for hours searching google with no help.
Can someone suggest what we may be doing wrong or what we should try?
Thank you very very much in advance