Loading Single Excel Worksheet Tab with TLB

Loading Single Excel Worksheet Tab with TLB - Printable Version

+- Tordex Community (http://forum.tordex.com)
+-- Forum: True Launch Bar (http://forum.tordex.com/forum-3.html)
+--- Forum: General Discussion (http://forum.tordex.com/forum-8.html)
+--- Thread: Loading Single Excel Worksheet Tab with TLB (/thread-4278.html)

Loading Single Excel Worksheet Tab with TLB - DocCruncher - 08-15-2012

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

RE: Loading Single Excel Worksheet Tab with TLB - Yuri Kobets - 08-18-2012

Is this possible without TLB? I'm not sure Confused

RE: Loading Single Excel Worksheet Tab with TLB - DocCruncher - 08-18-2012

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

RE: Loading Single Excel Worksheet Tab with TLB - Yuri Kobets - 08-18-2012

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.

RE: Loading Single Excel Worksheet Tab with TLB - DocCruncher - 08-18-2012

(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

RE: Loading Single Excel Worksheet Tab with TLB - Yuri Kobets - 08-18-2012

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.

RE: Loading Single Excel Worksheet Tab with TLB - DocCruncher - 08-18-2012

(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