open workbook directly to chart

S

Sharon

I have an intranet app that navigates to various types of
documents, including .xls files, stored on network
drives. Some docments have the relevant data buried among
irrelevant (for my purposes) worksheets and ranges of
data. I have found that I can go directly to a cell or
named range by opening the file with this javascript
command:

window.open('directoryName/FileName.xls#WorksheetName!
CellOrRangeReference')"

But now I have a document with several tabs that contain
charts only, rather than worksheets. The above command
does not work without a cell or range reference. but
there are no cells on these "worksheets", nor can I
define range names for them.

Can anyone tell me how to open the worksheet directly to
the chart I want?

TIA,
Sharon
 
A

AlfD

Hi!

Put something like this in the This Workbook module.

Private Sub Workbook_Open()
Sheets("Chart1").Select
End Sub

It won't work until after you have saved it and reloaded it.

Ask if you need more detail.

Al
 
G

Guest

Thanks Alf.

The propblem with this approach is that in I have more
than one chart in the workbook. The one I want the
workbook to open to varies depending on the link in the
html page that is clicked. Therefore I need a way to
specify in the link rather than in the .xls.

Any more suggestions?

Sharon
 
Top