See attached spreadsheet
the only thing you need to update is
change this to your directory![]()
Const strFolder As String = "C:\Downloads\" 'Directory
press the grey button and it should work
i added the hyperlink feature into this one as well
![]()
ActiveSheet.Hyperlinks.Add Anchor:=Cells(i, 5), Address:=strFolder & strFileName, TextToDisplay:=strFileName
Bookmarks