Hidden Sheets

[Buda56]

Bruce,
Hi.. Is there anyway to access sheets in a spreadshet that are
hidden? I am trying to access a spreadsheet where several of the
sheets are hidden.

Regards..
Peter

[shriop]

Unless you have the source code to make changes, no, I seem to have by
default not included any sheets that are hidden. It made sense to me
at the time, as I can't come up with a valid reason why someone would
be sending you data that you need on a sheet that they've hidden, but
I guess I can see the possibility of a setting to go ahead and include
them. I'd then probably need a property to say whether each sheet was
of type hidden or not.

Bruce Dunwiddie

[Buda56]

Bruce,
Thanks for the update, the sheets were hidden to stop people
from leaving the spreadsheet open as it get updated daily. When you
open the sheet you can only see the summary sheet, when opening in
excel 2007 security kicks in and you can reopen the sheet as a copy
that shows all sheets.

I have got around this for the minute by using OLEDB drivers to get
the particular sheet I'm after.

Regards..
Peter.

> > Peter- Hide quoted text -
>
> - Show quoted text -