VBA To Deliver Object List?

Can I write a single VBA loop to enumerate all objects within an Excel .XLS?

Or do I have to know the object types/container names and enumerate the contents
of each?
--
PeteCresswell

see:

http://www.microsoft.com/communities...9-2305acd4d167
--
Gary's Student


"(PeteCresswell)" wrote:

> Can I write a single VBA loop to enumerate all objects within an Excel .XLS?
>
> Or do I have to know the object types/container names and enumerate the contents
> of each?
> --
> PeteCresswell
>

Per Gary''s Student:
>http://www.microsoft.com/communities...9-2305acd4d167
>--

Seems like the object browser seems lists all available objects whether in use
or not - as opposed to the objects that actually are in use in the .XLS.

Have I got it right?

I'm trying to figure out how the author of a certain .XLS is managing to store a
half-million rows of data. The obvious way would be to have multiple invisible
sheets - but I cannot figure out how to browse for them.
--
PeteCresswell

If the worksheets are hidden you can try to look at the VBE's project explorer to see a list of all of the worksheets used hidden or not.

If they are there, you can use the command
worksheets(worksheetname).visible = true (repeat for each hidden sheet)

in a macro you could use

Please Login or Register  to view this content.

to unhide all of the sheets