Google Groups Home
Help | Sign in
Hidden Sheets
There are currently too many topics in this group that display first. To make this topic appear first, remove this option from another topic.
There was an error processing your request. Please try again.
flag
  3 messages - Collapse all
The group you are posting to is a Usenet group. Messages posted to this group will make your email address visible to anyone on the Internet.
Your reply message has not been sent.
Your post was successful
Buda56  
View profile
 More options Jun 10, 2:48 am
From: Buda56 <peter.annand...@eds.com>
Date: Mon, 9 Jun 2008 23:48:27 -0700 (PDT)
Local: Tues, Jun 10 2008 2:48 am
Subject: Hidden Sheets
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


    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
shriop  
View profile
 More options Jun 10, 3:37 pm
From: shriop <shr...@hotmail.com>
Date: Tue, 10 Jun 2008 12:37:18 -0700 (PDT)
Local: Tues, Jun 10 2008 3:37 pm
Subject: Re: Hidden Sheets
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

On Jun 10, 1:48 am, Buda56 <peter.annand...@eds.com> wrote:


    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Buda56  
View profile
 More options Jun 11, 6:11 pm
From: Buda56 <peter.annand...@eds.com>
Date: Wed, 11 Jun 2008 15:11:41 -0700 (PDT)
Local: Wed, Jun 11 2008 6:11 pm
Subject: Re: Hidden Sheets
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.

On Jun 11, 4:37 am, shriop <shr...@hotmail.com> wrote:


    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
End of messages
« Back to Discussions « Newer topic     Older topic »

Create a group - Google Groups - Google Home - Terms of Service - Privacy Policy
©2008 Google