A hypertext link to an Excel documents (questions)

[Robert]

I have a client who has setup an Excel (Excel 2002)
document to have the A column empty. When I link to that
document from a webpage and view the page in a browser (IE
6.0.28), some users have the Excel page open up to veiw
column A and others (most) have the document open to NOT
showing column A, but rather starting at showing column B.
What causes this? Is there anything I can do in the HTHL
to ensure tha file opens with column A showing?

Thank you very much.

 

[David McRitchie]

Hi Robert,
What does the link look like in the HTML.

Where does the Excel file exist, I guess you are opening it
to see that you don't have Column A.

 

[Robert]

<a
href="file://xxxxxx.xxxxx.xxxxxxxx.xxx/xxxx/xxxxxxxx.xls"

I had to put the x's in (confidentiality over here). The
file is on another server and when it opens up the view is
always scrolled over to start at column B.

Is there a way that I can have the file open to always
show the leftmost column and topmost row of an Excel file?

Thanks

Rob

-----Original Message-----
Hi Robert,
What does the link look like in the HTML.

Where does the Excel file exist, I guess you are opening it
to see that you don't have Column A.



"Robert" <[email protected]> wrote in

message news:[email protected]...

 

[David McRitchie]

Hi Robert,
I don't think this works -- maybe the triple x's on your site:
<a href="file://xxxxxx.xxxxx.xxxxxxxx.xxx/xxxx/xxxxxxxx.xls#sheet3!a30">a30</a>
<a href="file://xxxxxx.xxxxx.xxxxxxxx.xxx/xxxx/""xxxxxxxx.xls#sheet3!a30""">a30</a>

Seems that if it is for read only a zip file might be better than you
aren't asked for an additional password as needed, I guess,
to update the Excel file.

so how about simply having the following
in your ThisWorkBook, install by
right click on logo to the far left of menu bar and insert the
following code, modifying as appropriate, commenting or uncommenting
code.

Sub WorkBook_Open()
'Worksheets("Sheet1").Activate 'activate sheet by that name
Worksheets(2).Activate 'activate sheet in that position
Cells(1, 1).Activate 'start at row 1 column 1
End Sub

You now have macros and will have to reply to the macro
warning appropriately: