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.

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.

I don't think Chip's functions work with the locals window as requested by
the OP, although perhaps the end result is equivalent - just for possible
clarification.

--
Regards,
Tom Ogilvy

"keepITcool" wrote in message
...

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.

Tom, of course what you say is true,
I sought a way to provide OP with results..

But forgot to mention:

you cant READ the locals window.

it will only show properties when VBE when in BREAK mode.
and running some code on an instance which is in breakmode
would be a nice challenge in itself.



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

Tom Ogilvy wrote in message
:

I don't think Chip's functions work with the locals window as
requested by the OP, although perhaps the end result is equivalent -
just for possible clarification.

Just thought your post, while not intended to be confusing, might be
confusing with respect to the aspect of the question of harvesting from the
locals window. Thanks for the clarification.

--
Regards,
Tom Ogilvy

"keepITcool" wrote in message
...

Tom, of course what you say is true,
I sought a way to provide OP with results..

But forgot to mention:

you cant READ the locals window.

it will only show properties when VBE when in BREAK mode.
and running some code on an instance which is in breakmode
would be a nice challenge in itself.



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

Tom Ogilvy wrote in message
:

I don't think Chip's functions work with the locals window as
requested by the OP, although perhaps the end result is equivalent -
just for possible clarification.