Forum Discussion
Solved
Match Cell Value with File Name in Folder Directory and get it's Path
asdf;kasdoiashdoiashdoiaushdioasjdas MISAT
Why not simply
Sheet1.Hyperlinks.Add Anchor:=cel.Offset(, 1).Value, Address:=strFilepath, TextToDisplay:=cel.Value
Why not simply
Sheet1.Hyperlinks.Add Anchor:=cel.Offset(, 1).Value, Address:=strFilepath, TextToDisplay:=cel.Value
thanks workde