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-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.


Messages In This Thread
RE: Loading Single Excel Worksheet Tab with TLB - by DocCruncher - 08-18-2012, 09:05 AM

Forum Jump:


Users browsing this thread: 1 Guest(s)