How to Open Excel to a specific tab via the IE browser

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

I have an Excel sheet with 5 tabs and I need to be able to
launch the file via the IE browser BUT be able to specify
which tab to open up with initially. I.E. I want to
create a link that opens tab 1, another for tab 2, etc.

Any suggestions on how to do this?
(BTW, I have searched this board, but nothing jumped out
at me as the solution.)

Thanks,

Mike
 
Thanks for the help. I've tried your suggestion, but it
seems to truncate off after the .xls and ignore my
#Tab_Monday and #Tab_Tuesday.

Looking at the destination I can see that the path is set
up correctly and does include the #Tab-Monday, but when
the command is executed it just ignore the stuff after
the .xls. Looking at the top of the excel bar it shows
the path but stops at the .xls.

Any ideas of why this would be happening?

Again, I GREATLY appreciate the help on this!

Mike
 
Back
Top