hyperlink to a cell in Excel

[dn]

I am using Outlook 2003. I can't figure out the syntax of the URL to use in
an Outlook email that, when the email recipient clicks on the URL, will take
the email recipient to the specified cell in the specified sheet in the Excel
workbook.

Example: <file://\\server name\share name\file name.xls> merely opens the
file "file name.xls", and the focus is wherever it was when the file was last
saved, instead of going to cell A1 on sheet "sheet name".

If I try this: <file://\\server name\share name\file name.xls#sheet
name!A1> Outlook tells me that it cannot find the file "file name.xls#sheet
nate!a1". I don't know what to do, much searching on the internet has not
helped.

 

[Michael Bauer [MVP - Outlook]]

As I don't know the syntax either I'd do it with VBA. Use the Workbook_Open
event, and use the Range object to activate whatever you want.

--
Best regards
Michael Bauer - MVP Outlook

: Outlook Categories? Category Manager Is Your Tool
: VBOffice Reporter for Data Analysis & Reporting
: <http://www.vboffice.net/product.html?pub=6&lang=en>


Am Fri, 28 Aug 2009 08:56:01 -0700 schrieb dn:

 

[dn]

Thanks.

Unfortunately, just as you don't know the syntax, I don't know VB! I'm
hoping someone out there know the proper syntax for what I need to do (if it
can be done).

 

[Diane Poremsky [MVP]]

Try the excel groups - I found this but can't get it to work:
http://www.mrexcel.com/archive/Hyperlinks/21413.html

--
Diane Poremsky [MVP - Outlook]



Outlook Tips by email:
mailto:[email protected]

EMO - a weekly newsletter about Outlook and Exchange:
mailto:[email protected]

 

[Roady [MVP]]

I believe those type of links only work initiated from within Word or
another Office application.
As Outlook 2003 actually renders its messages via Internet Explorer, I don't
think this is possible.

Does it work when you execute that link from the Run command?

You might want to check in an Excel newsgroup to learn more about the
characteristics of constructing such a link.

FWIW: The sheet name should between single quotes or otherwise you're
referring to a named range.

 

[dn]

When I use the RUN command, it works if I specify the file only. I can't get
it to work if I specify the sheet or the sheet and the cell.

 

[Diane Poremsky [MVP]]

The file:// protocol works from a webpage - I can get a workbook open but it
ignores the bookmark. You really need to check with the excel experts to
find out if it is possible and the proper syntax. There should be a link to
the excel groups from the page you are using to access this group or you can
use the following link:
http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?dg=microsoft.public.excel

--
Diane Poremsky [MVP - Outlook]



Outlook Tips by email:
mailto:[email protected]

EMO - a weekly newsletter about Outlook and Exchange:
mailto:[email protected]

 

[Diane Poremsky [MVP]]

As an FYI - using a named range is supposed to work as a bookmark but its
apparently a bug in office 2007 that the bookmark gets dropped.

The file:// protocol works from a webpage - I can get a workbook open but
it ignores the bookmark. You really need to check with the excel experts
to find out if it is possible and the proper syntax. There should be a
link to the excel groups from the page you are using to access this group
or you can use the following link:
http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?dg=microsoft.public.excel

--
Diane Poremsky [MVP - Outlook]



Outlook Tips by email:
mailto:[email protected]

EMO - a weekly newsletter about Outlook and Exchange:
mailto:[email protected]

When I use the RUN command, it works if I specify the file only. I can't
get
it to work if I specify the sheet or the sheet and the cell.

 

[Michael Bauer [MVP - Outlook]]

Open the workbook, press alt+f11, press ctrl+r, double-click "ThisWorkbook",
and paste this code into the module; you need to modify the name of the
sheet and cell:

Private Sub Workbook_Open()
Dim Sheet$, Cell$
Dim Ws As Excel.Worksheet

Sheet = "Tabelle1"
Cell = "c5"

Set Ws = ThisWorkbook.Sheets(Sheet)
Ws.Activate
Ws.Range(Cell).Activate
End Sub

--
Best regards
Michael Bauer - MVP Outlook

: Outlook Categories? Category Manager Is Your Tool
: VBOffice Reporter for Data Analysis & Reporting
: <http://www.vboffice.net/product.html?pub=6&lang=en>



Am Fri, 28 Aug 2009 10:58:01 -0700 schrieb dn:

 

[Diane Poremsky [MVP]]

This requires macros to be enabled on the recipients system though. Using a
bookmark in a url doesn't.

--
Diane Poremsky [MVP - Outlook]



Outlook Tips by email:
mailto:[email protected]

EMO - a weekly newsletter about Outlook and Exchange:
mailto:[email protected]