hyperlink to another workbook and a specific sheet

Hello all.
Is it possible to use VBA to point to another workbook AND a specific sheet
?
There is no problem when the link is used manually. When using VBA, the link
is only pointing to the "address" part of the link, so you cannot reach the
sheet and cell you wanted.
Thanks in advance.
Daniel

Use the subaddress as well.

--
Regards,
Tom Ogilvy

"Daniel" <[email protected]> wrote in message
news:[email protected]...
> Hello all.
> Is it possible to use VBA to point to another workbook AND a specific
sheet
> ?
> There is no problem when the link is used manually. When using VBA, the
link
> is only pointing to the "address" part of the link, so you cannot reach
the
> sheet and cell you wanted.
> Thanks in advance.
> Daniel
>
>

Try naming the sheet and range in the Hyperlink's SubAddress.

Mike F
Daniel <[email protected]> wrote in message
news:[email protected]...
> Hello all.
> Is it possible to use VBA to point to another workbook AND a specific
sheet
> ?
> There is no problem when the link is used manually. When using VBA, the
link
> is only pointing to the "address" part of the link, so you cannot reach
the
> sheet and cell you wanted.
> Thanks in advance.
> Daniel
>
>

Thanks for your answer, it works fine.
Daniel
"Mike" <[email protected]> a écrit dans le message de news:
uHsW%[email protected]...
> Try naming the sheet and range in the Hyperlink's SubAddress.
>
> Mike F
> Daniel <[email protected]> wrote in message
> news:[email protected]...
>> Hello all.
>> Is it possible to use VBA to point to another workbook AND a specific
> sheet
>> ?
>> There is no problem when the link is used manually. When using VBA, the
> link
>> is only pointing to the "address" part of the link, so you cannot reach
> the
>> sheet and cell you wanted.
>> Thanks in advance.
>> Daniel
>>
>>
>
>

Thanks for your response.
Can you, please, be a little more explicit?
my code :
Range("C11").Hyperlinks(1).follow points only to the workbook
Daniel
"Tom Ogilvy" <[email protected]> a écrit dans le message de news:
[email protected]...
> Use the subaddress as well.
>
> --
> Regards,
> Tom Ogilvy
>
> "Daniel" <[email protected]> wrote in message
> news:[email protected]...
>> Hello all.
>> Is it possible to use VBA to point to another workbook AND a specific
> sheet
>> ?
>> There is no problem when the link is used manually. When using VBA, the
> link
>> is only pointing to the "address" part of the link, so you cannot reach
> the
>> sheet and cell you wanted.
>> Thanks in advance.
>> Daniel
>>
>>
>
>

I set up a hyperlink that would manually open a workbook and go to a
specific worksheet and cell.

Using your code worked fine for me.

You can examine your hyperlink with code

Sub TestHyperlink()
Dim sStr As String
With Range("C11").Hyperlinks(1)
sStr = "Address: " & .Address & vbNewLine & _
"SubAddress: " & .SubAddress
End With
MsgBox sStr
End Sub


If you don't get a subaddress, then there is your problem.


--
Regards,
Tom Ogilvy


"Daniel" <[email protected]> wrote in message
news:[email protected]...
> Thanks for your response.
> Can you, please, be a little more explicit?
> my code :
> Range("C11").Hyperlinks(1).follow points only to the workbook
> Daniel
> "Tom Ogilvy" <[email protected]> a écrit dans le message de news:
> [email protected]...
> > Use the subaddress as well.
> >
> > --
> > Regards,
> > Tom Ogilvy
> >
> > "Daniel" <[email protected]> wrote in message
> > news:[email protected]...
> >> Hello all.
> >> Is it possible to use VBA to point to another workbook AND a specific
> > sheet
> >> ?
> >> There is no problem when the link is used manually. When using VBA, the
> > link
> >> is only pointing to the "address" part of the link, so you cannot reach
> > the
> >> sheet and cell you wanted.
> >> Thanks in advance.
> >> Daniel
> >>
> >>
> >
> >
>
>

Yes, you get the address and subaddress correctly. The problem is that the
"follow" method seems not to use the subaddress property, as long as it is
refered with sheet and cell name (Feuil1!A2 for instance).
Daniel
"Tom Ogilvy" <[email protected]> a écrit dans le message de news:
%[email protected]...
>I set up a hyperlink that would manually open a workbook and go to a
> specific worksheet and cell.
>
> Using your code worked fine for me.
>
> You can examine your hyperlink with code
>
> Sub TestHyperlink()
> Dim sStr As String
> With Range("C11").Hyperlinks(1)
> sStr = "Address: " & .Address & vbNewLine & _
> "SubAddress: " & .SubAddress
> End With
> MsgBox sStr
> End Sub
>
>
> If you don't get a subaddress, then there is your problem.
>
>
> --
> Regards,
> Tom Ogilvy
>
>
> "Daniel" <[email protected]> wrote in message
> news:[email protected]...
>> Thanks for your response.
>> Can you, please, be a little more explicit?
>> my code :
>> Range("C11").Hyperlinks(1).follow points only to the workbook
>> Daniel
>> "Tom Ogilvy" <[email protected]> a écrit dans le message de news:
>> [email protected]...
>> > Use the subaddress as well.
>> >
>> > --
>> > Regards,
>> > Tom Ogilvy
>> >
>> > "Daniel" <[email protected]> wrote in message
>> > news:[email protected]...
>> >> Hello all.
>> >> Is it possible to use VBA to point to another workbook AND a specific
>> > sheet
>> >> ?
>> >> There is no problem when the link is used manually. When using VBA,
>> >> the
>> > link
>> >> is only pointing to the "address" part of the link, so you cannot
>> >> reach
>> > the
>> >> sheet and cell you wanted.
>> >> Thanks in advance.
>> >> Daniel
>> >>
>> >>
>> >
>> >
>>
>>
>
>

Like I said, it worked for me in xl2003.

If you can't get it to work, then perhaps you would need to use the
followhyperlink event to achieve the desired result.
--
Regards,
Tom Ogilvy


"Daniel" <[email protected]> wrote in message
news:[email protected]...
> Yes, you get the address and subaddress correctly. The problem is that the
> "follow" method seems not to use the subaddress property, as long as it is
> refered with sheet and cell name (Feuil1!A2 for instance).
> Daniel
> "Tom Ogilvy" <[email protected]> a écrit dans le message de news:
> %[email protected]...
> >I set up a hyperlink that would manually open a workbook and go to a
> > specific worksheet and cell.
> >
> > Using your code worked fine for me.
> >
> > You can examine your hyperlink with code
> >
> > Sub TestHyperlink()
> > Dim sStr As String
> > With Range("C11").Hyperlinks(1)
> > sStr = "Address: " & .Address & vbNewLine & _
> > "SubAddress: " & .SubAddress
> > End With
> > MsgBox sStr
> > End Sub
> >
> >
> > If you don't get a subaddress, then there is your problem.
> >
> >
> > --
> > Regards,
> > Tom Ogilvy
> >
> >
> > "Daniel" <[email protected]> wrote in message
> > news:[email protected]...
> >> Thanks for your response.
> >> Can you, please, be a little more explicit?
> >> my code :
> >> Range("C11").Hyperlinks(1).follow points only to the workbook
> >> Daniel
> >> "Tom Ogilvy" <[email protected]> a écrit dans le message de news:
> >> [email protected]...
> >> > Use the subaddress as well.
> >> >
> >> > --
> >> > Regards,
> >> > Tom Ogilvy
> >> >
> >> > "Daniel" <[email protected]> wrote in message
> >> > news:[email protected]...
> >> >> Hello all.
> >> >> Is it possible to use VBA to point to another workbook AND a
specific
> >> > sheet
> >> >> ?
> >> >> There is no problem when the link is used manually. When using VBA,
> >> >> the
> >> > link
> >> >> is only pointing to the "address" part of the link, so you cannot
> >> >> reach
> >> > the
> >> >> sheet and cell you wanted.
> >> >> Thanks in advance.
> >> >> Daniel
> >> >>
> >> >>
> >> >
> >> >
> >>
> >>
> >
> >
>
>

Thanks for all.
Daniel
"Tom Ogilvy" <[email protected]> a écrit dans le message de news:
[email protected]...
> Like I said, it worked for me in xl2003.
>
> If you can't get it to work, then perhaps you would need to use the
> followhyperlink event to achieve the desired result.
> --
> Regards,
> Tom Ogilvy
>
>
> "Daniel" <[email protected]> wrote in message
> news:[email protected]...
>> Yes, you get the address and subaddress correctly. The problem is that
>> the
>> "follow" method seems not to use the subaddress property, as long as it
>> is
>> refered with sheet and cell name (Feuil1!A2 for instance).
>> Daniel
>> "Tom Ogilvy" <[email protected]> a écrit dans le message de news:
>> %[email protected]...
>> >I set up a hyperlink that would manually open a workbook and go to a
>> > specific worksheet and cell.
>> >
>> > Using your code worked fine for me.
>> >
>> > You can examine your hyperlink with code
>> >
>> > Sub TestHyperlink()
>> > Dim sStr As String
>> > With Range("C11").Hyperlinks(1)
>> > sStr = "Address: " & .Address & vbNewLine & _
>> > "SubAddress: " & .SubAddress
>> > End With
>> > MsgBox sStr
>> > End Sub
>> >
>> >
>> > If you don't get a subaddress, then there is your problem.
>> >
>> >
>> > --
>> > Regards,
>> > Tom Ogilvy
>> >
>> >
>> > "Daniel" <[email protected]> wrote in message
>> > news:[email protected]...
>> >> Thanks for your response.
>> >> Can you, please, be a little more explicit?
>> >> my code :
>> >> Range("C11").Hyperlinks(1).follow points only to the workbook
>> >> Daniel
>> >> "Tom Ogilvy" <[email protected]> a écrit dans le message de news:
>> >> [email protected]...
>> >> > Use the subaddress as well.
>> >> >
>> >> > --
>> >> > Regards,
>> >> > Tom Ogilvy
>> >> >
>> >> > "Daniel" <[email protected]> wrote in message
>> >> > news:[email protected]...
>> >> >> Hello all.
>> >> >> Is it possible to use VBA to point to another workbook AND a
> specific
>> >> > sheet
>> >> >> ?
>> >> >> There is no problem when the link is used manually. When using VBA,
>> >> >> the
>> >> > link
>> >> >> is only pointing to the "address" part of the link, so you cannot
>> >> >> reach
>> >> > the
>> >> >> sheet and cell you wanted.
>> >> >> Thanks in advance.
>> >> >> Daniel
>> >> >>
>> >> >>
>> >> >
>> >> >
>> >>
>> >>
>> >
>> >
>>
>>
>
>