gmaxey
06-19-2014, 11:57 AM
I have some code that adds a hyperlink to a cell the hyperlink address and display is the path and file name of a Word document:
xlSheet.Hyperlinks.Add .Cells(lngRecordCount, 12), _
Address:="", SubAddress:=strPN, TextToDisplay:=strPN
Where strPN might be C:\My Documents\Test.docm
I would like to be able to click that hyperlink and the Word document then open in Word. It doesn't work (likely isn't supposed to). Can anyone advise how I could achieve the goal via other means? I want to be able to click in a cell and as a result Word will open to the document referenced in the cell. Thanks.
xlSheet.Hyperlinks.Add .Cells(lngRecordCount, 12), _
Address:="", SubAddress:=strPN, TextToDisplay:=strPN
Where strPN might be C:\My Documents\Test.docm
I would like to be able to click that hyperlink and the Word document then open in Word. It doesn't work (likely isn't supposed to). Can anyone advise how I could achieve the goal via other means? I want to be able to click in a cell and as a result Word will open to the document referenced in the cell. Thanks.