troubleshooting Question

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

Avatar of spar-kle
spar-kleFlag for United Kingdom of Great Britain and Northern Ireland asked on
Microsoft Excel
6 Comments1 Solution66 ViewsLast Modified:
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"
Robberbaron (robr)

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 6 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 6 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros