Hyperlinking from Outlook 2003 to an excel Worksheet

  • Thread starter Thread starter fidgitthedigit
  • Start date Start date
F

fidgitthedigit

I'm trying to insert a hyperlink in a Outlook-2003 generated e-mail to
a specific tab in a multi-sheet Spreadsheet. I have no problem getting

into the spreadsheet, but it will only go to where the file was
previously opened, and I want to be able to do this without creating
tags in the spreadsheet.

the hyperlink included in the e-mail is <file://\\mainserver\project
costs\time reporting\timesheet90995.xls> and I want to go to cell B6 in

tab April-06 directly by clicking the hyperlink in the e-mail message.


Excel seems to suggest that appending #'April-06'!B6 to the end of the
hyperlink will give me what I want, but it doesn't, the # just seems to

be a memo note.


Any suggestions?
 
Do you want the hyperlink to open in a browser or in Excel?

I would just use the UNC format:
\\mainserver\projectcosts\time%20reporting\timesheet90995.xls#April06!B6
maybe %20 for the space
and no quotes around the worksheet name (use URL friendly worksheet names
within the workbook, too)

This will open it up using Excel.
 
I want the hyperlink to open in Excel. I tried your suggestion (e.g.
substituting %20 for the space, etc..) and got the exact same result as
before, namely, I'm able to open the spreasheet OK, but it ignores the
bookmark reference, i.e. it opens at where the file was last opened.
In the example I provided, instead of opening at April06!B6, it opens
at May06 which is where I last modified the sheet.

There is a workaround, namely, using a transition excel file with a
built in macro that will move the cursor to the correct tab and
location in the spreadsheet, but I'm trying to avoid this intermediate
step.

Thanks
 
Back
Top