View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Peter T Peter T is offline
external usenet poster
 
Posts: 5,600
Default Need for speed - Beyond Excel VBA

Maybe your VBA code can be optimised, sometimes that can have the effect of
speeding things up very considerably, x10, x100 fold or more is often
possible.

If the exercise is only number crunching, a C++ dll or xll might be the way
to go.

My spreadsheet has grown too big,


Not sure what that means but maybe some redesign.

Regards,
Peter T



"BR" wrote in message
...
My spreadsheet has grown too big, and VBA takes too long to run stress
tests
on it !

Can I use Excel for deal presentation purposes only, run the algorithms
faster in another language and interface that to Excel, please suggest
directions

(My company doesn't have an IT desk, apologies if this is too basic a
query)

--
-----