hyperlink to a cell in Excel

Status
Not open for further replies.
#1
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

Senior Member
Outlook version
Outlook 2010 32 bit
Email Account
Exchange Server
#2


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

Am Fri, 28 Aug 2009 08:56:01 -0700 schrieb 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.

 
#3
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).

"Michael Bauer " wrote:

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

>

>

>
>
> Am Fri, 28 Aug 2009 08:56:01 -0700 schrieb 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.

>

 
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
#4
Try the excel groups - I found this but can't get it to work:
http://www.mrexcel.com/archive/Hyperlinks/21413.html

"dn" <dn> wrote in message
news:36523442-B693-4C5E-AC2B-5D62D5BCB3A0@microsoft.com...
> 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.


 
R

Roady [MVP]

#5
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" <dn> wrote in message
news:BA1C30A5-0435-4325-9CEF-7BFDFF075823@microsoft.com...
> 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).
>
> "Michael Bauer " wrote:
>
>>
>>
>> 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
>>
>>

>>

>>

>>
>>
>> Am Fri, 28 Aug 2009 08:56:01 -0700 schrieb 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.

>>

 
#6
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.

"Roady [MVP]" wrote:

> 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" <dn> wrote in message
> news:BA1C30A5-0435-4325-9CEF-7BFDFF075823@microsoft.com...
> > 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).
> >
> > "Michael Bauer " wrote:
> >
> >>
> >>
> >> 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
> >>
> >>

> >>

> >>

> >>
> >>
> >> Am Fri, 28 Aug 2009 08:56:01 -0700 schrieb 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.
> >>

>

 
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
#7
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

"dn" <dn> wrote in message
news:6C8B4038-229C-4209-927E-5B9EFAF4DA2E@microsoft.com...
> 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.
>
> "Roady [MVP]" wrote:
>
>> 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" <dn> wrote in message
>> news:BA1C30A5-0435-4325-9CEF-7BFDFF075823@microsoft.com...
>> > 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).
>> >
>> > "Michael Bauer " wrote:
>> >
>> >>
>> >>
>> >> 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
>> >>
>> >>

>> >>

>> >>

>> >>
>> >>
>> >> Am Fri, 28 Aug 2009 08:56:01 -0700 schrieb 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.
>> >>

>>

 
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
#8
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.

"Diane Poremsky [MVP]" <outlookmvp@msn.com> wrote in message
news:#TbdaCGKKHA.2516@TK2MSFTNGP02.phx.gbl...
> 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
>
> >

>

>

>
>

>

>
>

>

>
> "dn" <dn> wrote in message
> news:6C8B4038-229C-4209-927E-5B9EFAF4DA2E@microsoft.com...
>> 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.
>>
>> "Roady [MVP]" wrote:
>>
>>> 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" <dn> wrote in message
>>> news:BA1C30A5-0435-4325-9CEF-7BFDFF075823@microsoft.com...
>>> > 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).
>>> >
>>> > "Michael Bauer " wrote:
>>> >
>>> >>
>>> >>
>>> >> 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
>>> >>
>>> >>

>>> >>

>>> >>

>>> >>
>>> >>
>>> >> Am Fri, 28 Aug 2009 08:56:01 -0700 schrieb 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

Senior Member
Outlook version
Outlook 2010 32 bit
Email Account
Exchange Server
#9

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

Am Fri, 28 Aug 2009 10:58:01 -0700 schrieb 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).
>
> "Michael Bauer " wrote:
>
>>
>>
>> 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
>>
>>

>>

>>

>>
>>
>> Am Fri, 28 Aug 2009 08:56:01 -0700 schrieb 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.

>>

 
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
#10
This requires macros to be enabled on the recipients system though. Using a
bookmark in a url doesn't.

"Michael Bauer " <mb@mvps.org> wrote in message
news:1hkvxnd2y8q6d$.1dpp1cidw2gor.dlg@40tude.net...
>
> 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
>
>

>

>

>
>
>
> Am Fri, 28 Aug 2009 10:58:01 -0700 schrieb 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).
>>
>> "Michael Bauer " wrote:
>>
>>>
>>>
>>> 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
>>>
>>>

>>>

>>>

>>>
>>>
>>> Am Fri, 28 Aug 2009 08:56:01 -0700 schrieb 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.
>>>

 
Status
Not open for further replies.
Top