Loading Single Excel Worksheet Tab with TLB
Started by DocCruncher


Rate this topic
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5


6 posts in this topic
DocCruncher
Member
***


0
115 posts 21 threads Joined: Oct 2009
08-15-2012, 08:16 PM -
#1
Is there a way to load a single Excel worksheet TAB with a TLB shortcut?

EXAMPLE: I have an Excel workbook with 10 tabs (worksheets). I want to open tab number 3 only and not the last tab that the workbook was saved to.

I can do this through another Excel workbook either with Hyperlinks or VBA but I want to do it through TLB.

Is there an extension that I can add to the TLB shortcut to allow opening just the tab that I want?

Thanks;
Doc
This post was last modified: 08-16-2012, 09:50 AM by DocCruncher.
Yuri Kobets
Posting Freak
*****


10
6,208 posts 429 threads Joined: Jan 2002
08-18-2012, 02:15 AM -
#2
Is this possible without TLB? I'm not sure Confused
The TORDEX Team
http://www.tordex.com
DocCruncher
Member
***


0
115 posts 21 threads Joined: Oct 2009
08-18-2012, 07:26 AM -
#3
Hi Yuri;

I don't understand the answer...
"Is this possible without TLB? I'm not sure "

WITHOUT TLB?

That's' not what I'm asking. I want to load the worksheet tab THROUGH (or WITH) a TLB shortcut.

Thanks;
Doc
Yuri Kobets
Posting Freak
*****


10
6,208 posts 429 threads Joined: Jan 2002
08-18-2012, 08:33 AM -
#4
I'm sorry, I don't know how to load the single worksheet tab. I'm not sure this is possible, Excel loads the file not a part of file.
The TORDEX Team
http://www.tordex.com
DocCruncher
Member
***


0
115 posts 21 threads Joined: Oct 2009
08-18-2012, 09:05 AM -
#5
(08-18-2012, 08:33 AM)Yuri Kobets Wrote: I'm sorry, I don't know how to load the single worksheet tab. I'm not sure this is possible, Excel loads the file not a part of file.

True, but Excel allows you to load the file with a specified tab open; this can be done within Excel two ways that I know of...
1: Through a... Hyperlink Current folder & Bookmarks (the Bookmarks are the individual Excel worksheet tabs).
2: Through... VBA file open command with the file tab as an extension.

What I am thinking is if it can be done through VBA (with a switch for the tab) it should be possible to do it with the proper switch within a TLB shortcut. I just can't find the correct switch to do the job through TLB shortcuts.

Thanks;
Doc
This post was last modified: 08-18-2012, 09:06 AM by DocCruncher.
Yuri Kobets
Posting Freak
*****


10
6,208 posts 429 threads Joined: Jan 2002
08-18-2012, 09:56 AM -
#6
Quote:1: Through a... Hyperlink Current folder & Bookmarks (the Bookmarks are the individual Excel worksheet tabs).
Is this possible to craete shortcut on the desktop? If yes, just copy this shortcut to TLB.

Quote:2: Through... VBA file open command with the file tab as an extension.
OK, you can create VBA file and place shortcut on TLB.
The TORDEX Team
http://www.tordex.com
DocCruncher
Member
***


0
115 posts 21 threads Joined: Oct 2009
08-18-2012, 10:42 AM -
#7
(08-18-2012, 09:56 AM)Yuri Kobets Wrote:
Quote:1: Through a... Hyperlink Current folder & Bookmarks (the Bookmarks are the individual Excel worksheet tabs).
Is this possible to craete shortcut on the desktop? If yes, just copy this shortcut to TLB.

No, Hyperlinks are strictly between MS Office applications.

Quote:2: Through... VBA file open command with the file tab as an extension.
OK, you can create VBA file and place shortcut on TLB.

I have been thinking the same thing; will give it a try.

Thanks;
Doc


Forum Jump:


Users browsing this thread: 2 Guest(s)