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 wrote in message
...
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" wrote in message
...
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" a écrit dans le message de news:
...
Try naming the sheet and range in the Hyperlink's SubAddress.

Mike F
Daniel wrote in message
...
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" a écrit dans le message de news:
...
Use the subaddress as well.

--
Regards,
Tom Ogilvy

"Daniel" wrote in message
...
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" wrote in message
...
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" a écrit dans le message de news:
...
Use the subaddress as well.

--
Regards,
Tom Ogilvy

"Daniel" wrote in message
...
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" a écrit dans le message de news:
...
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" wrote in message
...
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" a écrit dans le message de news:
...
Use the subaddress as well.

--
Regards,
Tom Ogilvy

"Daniel" wrote in message
...
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" wrote in message
...
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" a écrit dans le message de news:
...
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" wrote in message
...
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" a écrit dans le message de news:
...
Use the subaddress as well.

--
Regards,
Tom Ogilvy

"Daniel" wrote in message
...
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" a écrit dans le message de news:
...
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" wrote in message
...
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" a écrit dans le message de news:
...
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" wrote in message
...
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" a écrit dans le message de news:
...
Use the subaddress as well.

--
Regards,
Tom Ogilvy

"Daniel" wrote in message
...
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