Forum Discussion

JohnTaylor20's avatar
JohnTaylor20
Copper Contributor
Sep 12, 2024

Match Cell Value with File Name in Folder Directory and get it's Path

asdf;kasdoiashdoiashdoiaushdioasjdas

 

 

 

MISAT

  • JohnTaylor20 

    Why not simply

     

    Sheet1.Hyperlinks.Add Anchor:=cel.Offset(, 1).Value, Address:=strFilepath, TextToDisplay:=cel.Value

Resources