Hyperlink in XL07

  • Thread starter Thread starter RagDyeR
  • Start date Start date
R

RagDyeR

Can anyone tell me if the Hyperlink() function in XL07 will work if the WB
name and file extension is *not* included?
 
I can't believe that no one knows ! ? ! ?

Anyway, feed-back from the OP verified that it's still necessary.
 
Hi Rick

recording a macro to insert a hyperlink in both XL2003 and 2007 produces
identical code

Range("A1").Select
ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:="", SubAddress:=
_
"Sheet3!A1", TextToDisplay:="a"

Reading the link created, both show the full Path and Workbook name with
extension, so I cannot see any difference in the behaviour of either
version.
 
Thanks Roger.
--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

Hi Rick

recording a macro to insert a hyperlink in both XL2003 and 2007 produces
identical code

Range("A1").Select
ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:="", SubAddress:=
_
"Sheet3!A1", TextToDisplay:="a"

Reading the link created, both show the full Path and Workbook name with
extension, so I cannot see any difference in the behaviour of either
version.
 
Back
Top