View Single Post
  #2   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.programming,microsoft.public.office.developer.vba
jaf jaf is offline
external usenet poster
 
Posts: 300
Default 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)