08-18-2012, 09:05 AM -
(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.