Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Custom Functions in C/C++ against in VBA
Hi All
I have written a couple of custom functions for use in Excel using VBA Whilst the time taken to execute them individually is not awfully long when I have reasonably extensive use of them in any workboo particularly when the search array is reasonably big, say of the orde of 2000 rows by 10 columns, there is a noticeable drop in th recalculation time. I am advised that this is more than likely due to the overhead of usin VBA or the premium you pay for writing them in VBA (for the ease o coding in VBA particularly in the handing of variant data types against writing them in C++ or C for that matter. If this is the case, I would like to rewrite these functions in C ( can program in C relatively OK). I would need to read a range of cells from a worksheet and transfer th cell contents in to an array of variants. I would now need to pass thi array just created to a C function that I would call from another VB custom function - the idea being to do the processing of data in rather than in VBA with the called C function returning a doubl values. Any assistance shall be highly valued. Best regards Deepak Agarwa -- Message posted from http://www.ExcelForum.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom functions | Excel Discussion (Misc queries) | |||
Custom Functions | Excel Worksheet Functions | |||
Custom Functions | Excel Discussion (Misc queries) | |||
Using custom functions within custom validation | Excel Discussion (Misc queries) | |||
Custom Functions | Excel Programming |