Hello i tried to enter hyperlink by vba but every time i get Error 1004.
Code i am using:
Also tried:
I tried bunch of different stuff.
ProjectFolder return value of: "K:\Projektid\2018\Uus kaust_New Folder\_2 Joonised_drawings\WorkNo"
What code does is it takes on workbook values open another workbook and gives it some values and also want to give workbook location hyperlink(only thing that does not want to work).
Can anyone suggest what i am doing wrong.
Code i am using:
Code:
ActiveSheet.Range("G" & LastRow2).Parent.Hyperlinks.Add Anchor:=ActiveSheet.Range("G" & LastRow2), Address:=ProjectFolder, TextToDisplay:="Drawings"
Also tried:
Code:
WoBok2.Worksheets("Sheet1").Hyperlinks.Add Anchor:=WoBok2.Worksheets("Sheet1").Range("G" & LastRow2), Address:=ProjectFolder
I tried bunch of different stuff.
ProjectFolder return value of: "K:\Projektid\2018\Uus kaust_New Folder\_2 Joonised_drawings\WorkNo"
What code does is it takes on workbook values open another workbook and gives it some values and also want to give workbook location hyperlink(only thing that does not want to work).
Can anyone suggest what i am doing wrong.