<div>
i think so using the FileSystemObject, &nbsp;<a href="http://mahimavbscript.blogspot.com.au/2010/09/file-system-object-vs-files.html" rel="ugc">http://mahimavbscript.blogspot.com.au/2010/09/file-system-object-vs-files.html</a> &nbsp;or <a href="http://www.exceltrick.com/formulas_macros/filesystemobject-in-vba/" rel="ugc">http://www.exceltrick.com/formulas_macros/filesystemobject-in-vba/</a><br />
<br />
FileInfo.DateLastModified &nbsp;but the harder part will be matching the times as it's not a field that you can search by. &nbsp;Is there any other part of filename that can help reduce the number of files that will have to be check for time, other than tif extension ?
</div>


hl-update1.xls

<div>
Thanks for your support robr, appreciate it.<br />
Sorry for delay in returning ...trying to get code to work<br />
<br />
From what I can see, the code looks at the existing hyperlink and attempts to find the file within the same folder.<br />
Is that correct?<br />
in other words, how does it know the source folder path?<br />
<br />
I haven't successfully amended the HL yet...
</div>


<div>
the source folder is also within the Hyperlink. &nbsp; &nbsp;I assumed that the source folder was correct, just not the file name....<br />
<br />
fileaddress = thisHL.Address<br />
sFileFolder = FSO.GetParentFolderName(fi<wbr />leaddress)<wbr />
</div>


<div>
OK thanks.<br />
I will pursue this and let you know how I get on
</div>


<div>
Brilliant!! Thanks for your help
</div>


<div>
<div class="content wysiwyg-content">
I have a worksheet with 11366 lines.<br />
Each value in column B is hyper linked to either a xls, pdf or a tif file.<br />
Each row of data and hyper links are automatically created with a macro.<br />
Column A contains a date and time that the file was created. <br />
The time will be correct within about 3 seconds<br />
<br />
For some reason the hyper links for the pdf files and xls files are ok but the tif files are not always correct.<br />
<br />
I would like to recreate the hyper links to the tif files with a macro that looks in a specified folder and matches the date and time in column A with the &quot;Date Modified&quot; of the file, and creates the hyperlink in column B.<br />
<br />
Format of date in column A is &quot;03/02/2016 &nbsp;14:10:27&quot;
</div>
</div>


I have a worksheet with 11366 lines.
Each value in column B is hyper linked to either a xls, pdf or a tif file.
Each row of data and hyper links are automatically created with a macro.
Column A contains a date and time that the file was created. 
The time will be correct within about 3 seconds

For some reason the hyper links for the pdf files and xls files are ok but the tif files are not always correct.

I would like to recreate the hyper links to the tif files with a macro that looks in a specified folder and matches the date and time in column A with the "Date Modified" of the file, and creates the hyperlink in column B.

Format of date in column A is "03/02/2016  14:10:27"

Is it possible to replace hyperlinks in a worksheet using the Date Modified info of a file?

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.