it IS possible, but VERY complicated.

You'll need Microsoft's TLBINF32.dll
to read the typelibraries and enumerate properties.

Chip Pearson has done some "wrapping" work on it,
but you'll find it's still complex.

http://www.cpearson.com/excel.htm
then look for XLTLI Type Lib utilities.



--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam

Alan wrote in message
:


Hi All,

For some time now I have thought it would be useful to be able to pull
the contents of the 'locals' window out into either a worksheet or
some
other form (text file perhaps).

More specifically, where I am not entirely familar with an object, it
would be good to be able to blow out all the sub-branches and see
every property and the current value printed out or something.

Is this possible somehow?

Thanks,

Alan.