![]() |
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