Excel file Problem

[Shevira]

How can i create a weblink that will open an excel file (.xls) and makes that file to open in a specific pane/tab within it?

People in my division need to go to their specific pane within that excel file, but they are accessing it through the internet.

Someone just told me this could be achieved with an ACITVEX thing... any suggestions about my problem ?? Maybe a macro ?

Thanks,

Shev.

[LFCFan]

Hello,

Unfortunately you can't control where an Excel document opens. There are no ActiveX controls to my knowledge that can force an Excel document (or other Office doc) to open in a frame you specify.

You can tell IE to open a HTML doc in a frame by simply using:

<a href = "somefile.html" target = "myFrame">

or in a new window:

<a href = "somefile.html" target = "_new">

or in the same window:

<a href = "somefile.html" target = "_self">

As far as I know, the way the browser handles the opening of office documents is defined by the user as it is a security risk to allow documents to be opened in a frame.


----edit: Sorry I misunderstood. See next post.

HTH
Joe

[LFCFan]

I think this might be what you need:

In the Excel file's WorkBook_Open() module:

Private Sub Workbook_Open()

Set ExObj = CreateObject("wscript.network")
'*****create a network object
thisUser = ExObj.UserName
'***** get the user id
If thisUser = "sheviras_network_id" Then Sheets(2).Select
'*****check what the user id is and redirect to the appropriate tab
Set ExObj = Nothing
'*****destroy the network object


End Sub

This script gets the user's logon ID and redirects them to a sheet accordingly.

Define your link to the excel file like so:

<a href = "myExcelFile.xls"> My Excel File </a>

HTH!
Joe