Hyperlink Help
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\PP M\" '& 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 |
Hyperlink Help
Hi Pete,
This might help: Sub Hyperlink() ActiveWorkbook.FollowHyperlink Address:="C:\myrouteaddressgoeshere\Programming\PP M\" & ActiveSheet.Range("C2").Text & ".xls" End Sub Kind Regards, Tara "retepallen" wrote: 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\PP M\" '& 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 |
All times are GMT +1. The time now is 01:13 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com