Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.office.developer.vba,microsoft.public.excel.programming,microsoft.public.excel.misc,microsoft.public.excel
|
|||
|
|||
Excel and C/C++
Hi all,
For an Excel front-end GUI user interface, what's the best way to interface it with a back-end computational engine using C/C++? I guess there are numerous ways that can handle this -- I am looking for a method that is not too complicated(I am not very experienced in Excel/VBA programming), and most efficient ... Thanks a lot |
#2
Posted to microsoft.public.office.developer.vba,microsoft.public.excel.programming,microsoft.public.excel.misc,microsoft.public.excel
|
|||
|
|||
Excel and C/C++
There are a variety of techniques you could use, depending on specifically
what you want to accomplish and what version(s) of Excel you need to support. XLL This will work in any version of Excel, but you are limited to writing functions that return a value or using the XL4 Macro language features. XLLs don't support much in object model of current versions of Excel. However, an XLL has very fast performance, the fastest of any method. There are a number of template frameworks available on the net that do much of the housekeeping task for you. COM Add-In This will work in Excel 2000 and later and provides full object model support. Automation Add-In This will work in Excel 2002 and later. You can call functions in an Automation Add-In directly from worksheet cells. Visual Studio Tools For Office This will work in Excel 2003 and 2007. This gives you full access to the Excel object model plus the entire NET framework. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com (email address is on the web site) "cfman" wrote in message ... Hi all, For an Excel front-end GUI user interface, what's the best way to interface it with a back-end computational engine using C/C++? I guess there are numerous ways that can handle this -- I am looking for a method that is not too complicated(I am not very experienced in Excel/VBA programming), and most efficient ... Thanks a lot |
#3
Posted to microsoft.public.office.developer.vba,microsoft.public.excel.programming,microsoft.public.excel.misc,microsoft.public.excel
|
|||
|
|||
Excel and C/C++
"Chip Pearson" wrote in message ... There are a variety of techniques you could use, depending on specifically what you want to accomplish and what version(s) of Excel you need to support. XLL This will work in any version of Excel, but you are limited to writing functions that return a value or using the XL4 Macro language features. XLLs don't support much in object model of current versions of Excel. However, an XLL has very fast performance, the fastest of any method. There are a number of template frameworks available on the net that do much of the housekeeping task for you. COM Add-In This will work in Excel 2000 and later and provides full object model support. Automation Add-In This will work in Excel 2002 and later. You can call functions in an Automation Add-In directly from worksheet cells. Visual Studio Tools For Office This will work in Excel 2003 and 2007. This gives you full access to the Excel object model plus the entire NET framework. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com (email address is on the web site) Great! Thanks a lot for your help! Which approach is the easiest considering my lack of experiences in Excel/VBA coding? My goal is to specify a bunch of parameters in Excel, and hit a button in Excel to send the parameters to the back-end C++ computational engine, and then send results back to Excel, and then hopefully Excel will generate a plot, let's say a 2D plot, etc. I know how to design a button in Excel, but that's linked to a macro in VBA; I don't know how to link that button to C++, and how to let the Excel program wait for the results and display a plot afterwards... Could you please elaborate? Thanks a lot and have a great weekend! |
#4
Posted to microsoft.public.office.developer.vba,microsoft.public.excel.programming,microsoft.public.excel.misc,microsoft.public.excel
|
|||
|
|||
Excel and C/C++
"Chip Pearson" wrote in message ... There are a variety of techniques you could use, depending on specifically what you want to accomplish and what version(s) of Excel you need to support. XLL This will work in any version of Excel, but you are limited to writing functions that return a value or using the XL4 Macro language features. XLLs don't support much in object model of current versions of Excel. However, an XLL has very fast performance, the fastest of any method. There are a number of template frameworks available on the net that do much of the housekeeping task for you. COM Add-In This will work in Excel 2000 and later and provides full object model support. Automation Add-In This will work in Excel 2002 and later. You can call functions in an Automation Add-In directly from worksheet cells. Visual Studio Tools For Office This will work in Excel 2003 and 2007. This gives you full access to the Excel object model plus the entire NET framework. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com (email address is on the web site) Hi Chip, Thanks a lot for your help! I was also wondering if the following scheme is possible: Users set parameters in Excel, and then hit a button to launch my C/C++ program, which does all the computations, and then waits for the C/C++ program to send back the results; once the results are available, the Excel program will plot the results. My question is: how does the Excel program knows if the results have been sent back by the C/C++ program and are available? More specifically, I guess when the users hit a button, it's going to be a VBA macro, then how does VBA macro handles the above interface back and forth with C/C++ back-end? Thanks a lot |
#5
Posted to microsoft.public.office.developer.vba,microsoft.public.excel.programming,microsoft.public.excel.misc,microsoft.public.excel
|
|||
|
|||
Excel and C/C++
cfman wrote:
Hi Chip, Thanks a lot for your help! I was also wondering if the following scheme is possible: Users set parameters in Excel, and then hit a button to launch my C/C++ program, which does all the computations, and then waits for the C/C++ program to send back the results; once the results are available, the Excel program will plot the results. My question is: how does the Excel program knows if the results have been sent back by the C/C++ program and are available? More specifically, I guess when the users hit a button, it's going to be a VBA macro, then how does VBA macro handles the above interface back and forth with C/C++ back-end? Thanks a lot There's an entire book about developing financial XLLs in C++. See this article and the book references at the end. http://msdn2.microsoft.com/en-us/library/aa730920.aspx -- Scott McPhillips [VC++ MVP] |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|