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?
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?