benf.org : excel stuff

VBProf

Seriously, development only. This will give your children diseases, crash your sheet, leak like hell and probably neuter the family dog.
(Last updated 07/04) Actually, I've lost the source for this, but it's still here for playing with..

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

Last updated 07/2006
Vi is just great