what about dll application
-
I would like to create a vc++ application which could be used from excel. in fact i would like to use the calculation possibilities from c++ and use the environment of excel. I heard that i have to create a dll application, but i never do that before, so i would like to know if anybody could give me a sample of code or indicate me a place where i could find some explanation to do that. thanks in advance gerald
-
I would like to create a vc++ application which could be used from excel. in fact i would like to use the calculation possibilities from c++ and use the environment of excel. I heard that i have to create a dll application, but i never do that before, so i would like to know if anybody could give me a sample of code or indicate me a place where i could find some explanation to do that. thanks in advance gerald
-
there's an MSDN sample called COMEXCEL, which controls an Excel-programm out of a c++-app. Maybe youcan make it go in the other direction! good luck!
i don't want to control excel, i just want to do some calculation with c++ from excel so that i could use the excel environment and benefit of the vc++ compilation do you see what i mean?
-
i don't want to control excel, i just want to do some calculation with c++ from excel so that i could use the excel environment and benefit of the vc++ compilation do you see what i mean?
You'll probably need to create a COM DLL that can be called from Excel VBA via the CreateObject method. Michael :-)
-
You'll probably need to create a COM DLL that can be called from Excel VBA via the CreateObject method. Michael :-)
could you tell me more about this way of working? thanks
-
could you tell me more about this way of working? thanks
It depends on what your are trying to achieve but in theory, Create an ATL DLL with a Simple COM object, add your methods to the object. In Excel create your VBA code to call your functions and return your results. If you need a more detailed answer, you'll need to supply more information about what you want to do. Michael :-)
-
I would like to create a vc++ application which could be used from excel. in fact i would like to use the calculation possibilities from c++ and use the environment of excel. I heard that i have to create a dll application, but i never do that before, so i would like to know if anybody could give me a sample of code or indicate me a place where i could find some explanation to do that. thanks in advance gerald
Do a search on MSDN for "Excel COM Add-ins and Automation Add-ins" or do a search for Office COM Add-ins. Michael :-)
-
It depends on what your are trying to achieve but in theory, Create an ATL DLL with a Simple COM object, add your methods to the object. In Excel create your VBA code to call your functions and return your results. If you need a more detailed answer, you'll need to supply more information about what you want to do. Michael :-)
in fact, even i'm not sure if it's possible, i would like to creta a library of functions which could be called from excel or vba, i don't know, so that as i need some array of inputs which are created in excel, i could use the inputs parameters in excel and use c++ methods to do calculations. is it enough to help me, because it will be very difficult to specify all my application in only few words. thanks gerald