VBA Hyperlinks.Add
用VBA 在 EXCEL 加入LINK
Private Sub hyper()
ActiveCell.Hyperlinks.Add Anchor:=Sheets("sub").Range("B1"), Address:="D:\file.txt", SubAddress:="", ScreenTip:="it is a Hyperlink", TextToDisplay:="Excel Training"
End Sub
用VBA 在 EXCEL 加入LINK
Private Sub hyper()
ActiveCell.Hyperlinks.Add Anchor:=Sheets("sub").Range("B1"), Address:="D:\file.txt", SubAddress:="", ScreenTip:="it is a Hyperlink", TextToDisplay:="Excel Training"
End Sub