benf.org : excel stuff |
Profile function mode VB at top level with eprof.xll & vbprof.xls. In an EMPTY excel session, (prior to using VB), load the addin. Use the sheet to see what's what.
This detours IDispatch, which allows us to intercept calls to VB from excel; we don't know what the function name is, but we can check the cell which called the function, and determine the name of the function from that. (or determine one of several it may have been...)
Example sheet using expensive VB - pand.xls
(Functional Model Development)
This is a framework I created at Barclays Capital. It's sufficiently novel that I gave a presentation on it at CUFP2009. Ordinarily I wouldn't publish work stuff here, but since it's on the public internet, it's nice to have a link. (embarassing video, in which I probably sound about twelve.)
(More of a placeholder for the search engines) - A little look at some N^2 dependency discovery behaviour in Excel.
The office clipboard doesn't have an API, but we can add one.
An analysis of the cost of registering large amounts of functions in Excel, and suggestions of how to work around costs.
Negative zero is a perfectly valid floating point number, but it can make excel hang.
There are significant (embarassingly so) performance issues with Excel 365's spill restriction / intersection operator '@'.
Last updated 11/2020 |