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

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
 
M

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top