| Home |
| Search |
| Today's Posts |
|
#1
Posted to alt.comp.lang.vba,microsoft.public.excel,microsoft.public.excel.programming,microsoft.public.office.developer.vba
|
|||
|
|||
call dll's from Excel asynchronously ?
Hello,
I have an Excel Addin, in which I call an DLL which retrieves data from a Iseries application. In Excel the cells contain an formula which is fed to the DLL. This works great except when using lots of cells and formula executiontime takes a while because Excel (re)calculates the cells one by one. Is it possible and how to that Excel calculates the cells not one by one but asynchronously, for example 5 at a time ? This would decrease the recalculationtime. Other suggestions to speed up are also welcome ! Best regards, Emile Besseling (remove geenspam) |
|
#2
Posted to microsoft.public.excel,microsoft.public.excel.programming,microsoft.public.office.developer.vba
|
|||
|
|||
|
call dll's from Excel asynchronously ?
Hi Emile,
Are you call the dll functions from worksheet formula or VBA? -- John johnf202 at hotmail dot com "Emile Besseling" wrote in message l.nl... Hello, I have an Excel Addin, in which I call an DLL which retrieves data from a Iseries application. In Excel the cells contain an formula which is fed to the DLL. This works great except when using lots of cells and formula executiontime takes a while because Excel (re)calculates the cells one by one. Is it possible and how to that Excel calculates the cells not one by one but asynchronously, for example 5 at a time ? This would decrease the recalculationtime. Other suggestions to speed up are also welcome ! Best regards, Emile Besseling (remove geenspam) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| What do you call the part in Excel.... | Excel Discussion (Misc queries) | |||
| How do I invoke a call in Excel | Excel Discussion (Misc queries) | |||
| CALL .NET FUNCTION FROM EXCEL | Excel Worksheet Functions | |||
| how do I put the do not call list in excel...does not fit | Excel Discussion (Misc queries) | |||
| Call Center Management: How to calculate 'cost per call' | Excel Discussion (Misc queries) | |||
Linear Mode
