an advice for a book
-
If i want to learn how i could do an application in vc++ which will be used in excel; for example my application need to catch data in excel, so for that it has to read into an array of value to catch input parameters for member method. I have heard that if i want to use regular dll i won't be able to use c++ functions. is it true? And in a last time if i use dlls, must i use "export" method or some method which call the function defined in vc++ from vba? so i would like to know if i could find help and samples in books or if someone could show me how to do? thanks in advance for your answers gerald
-
If i want to learn how i could do an application in vc++ which will be used in excel; for example my application need to catch data in excel, so for that it has to read into an array of value to catch input parameters for member method. I have heard that if i want to use regular dll i won't be able to use c++ functions. is it true? And in a last time if i use dlls, must i use "export" method or some method which call the function defined in vc++ from vba? so i would like to know if i could find help and samples in books or if someone could show me how to do? thanks in advance for your answers gerald
CUJ had an article about a year ago on doing this through COM, you essentially create a COM object which manipulates an Excel table. I can't remember the details, but it's probably online at www.cuj.com Christian I have come to clean zee pooollll. - Michael Martin Dec 30, 2001 Picture the daffodil. And while you do that, I'll be over here going through your stuff.
-
If i want to learn how i could do an application in vc++ which will be used in excel; for example my application need to catch data in excel, so for that it has to read into an array of value to catch input parameters for member method. I have heard that if i want to use regular dll i won't be able to use c++ functions. is it true? And in a last time if i use dlls, must i use "export" method or some method which call the function defined in vc++ from vba? so i would like to know if i could find help and samples in books or if someone could show me how to do? thanks in advance for your answers gerald
Check these out HOWTO: Use MFC to Automate Excel and Obtain an Array from a Range HOWTO: Use MFC to Create a Microsoft Excel Chart Atul PS: Search Google for COM Automation Excel Data Sonork ID : 100.13714
-
Check these out HOWTO: Use MFC to Automate Excel and Obtain an Array from a Range HOWTO: Use MFC to Create a Microsoft Excel Chart Atul PS: Search Google for COM Automation Excel Data Sonork ID : 100.13714
i don't want to automate excel i would like to use excel as you could use it with vb for application in the sense that from a cell you could call the function you need which have been initially implemented in vc++. So do you think that i could information and samples for my application? thanks gerald
-
i don't want to automate excel i would like to use excel as you could use it with vb for application in the sense that from a cell you could call the function you need which have been initially implemented in vc++. So do you think that i could information and samples for my application? thanks gerald
You can call a DOS program using the VBA Shell statement in sync or async. An application can be called using the VBA AppActivate statement. So you can implement your automation functions in VC++ apps. Hope it helps... Atul Sonork ID : 100.13714