Hyperlink Help

[retepallen]

Hi,

I'm trying to create a hyperlink to open another workbook and so far i have
got this code:

Sub Hyperlink()
ActiveWorkbook.FollowHyperlink
Address:="C:\myrouteaddressgoeshere\Programming\PPM\" '&
ActiveWorkbook.Cells("C2").Text & ".xls"
End Sub

When i put the direct link as one text file, then it opens fine. But i want
it to be able to open different files based on what is in Cell C2.

Any help would be appreciated.

Pete

 

[Tara H]

Hi Pete,

This might help:

Sub Hyperlink()
ActiveWorkbook.FollowHyperlink
Address:="C:\myrouteaddressgoeshere\Programming\PPM\" &
ActiveSheet.Range("C2").Text & ".xls"
End Sub

Kind Regards,
Tara