Date Modified for Hyperlinked file

  • I have an excel file with a list of projects (~500). Every active project has a hyperlinked status report. I want to add a column showing the date that the hyperlinked status report was last modified (so I can keep track of who is not updating their status reports).
    Not every project in the list is active so not every row has a hyperlink.

    Project Names are in Column A along with a bunch of other information in subsequent columns.

    The Hyperlink to the Status report is listed in Column AI.

    I want to put into Column AJ the date that the hyperlinked file was last modified.

    Hyperlinks exist in Column AI between rows 4 and 500 (though not every row in column AI has a hyperlink)

    I have found a few things online but have not been able to cobble together a functioning code.
    Any help would be appreciated.

    Thank you

  • Try this. I've left some code segments in incase you wanna use those too. Its a modified version of an old macro of mine

  • Thank you for the help.

    I tried the above code but received an error.

    Run-time error '1004':
    Application-defined or object-defined error

    Walking through the code, it seems to get through the If line but then generates the error.

    I also realized I did not state that the hyperlink goes to a SharePoint file. I am not sure if that makes a difference.

    Again, thank you for any help

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!