ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Hyperlinking from Outlook 2003 to an excel Worksheet (https://www.excelbanter.com/excel-discussion-misc-queries/86848-hyperlinking-outlook-2003-excel-worksheet.html)

fidgitthedigit

Hyperlinking from Outlook 2003 to an excel Worksheet
 
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?



All times are GMT +1. The time now is 08:09 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com