How to validate links to external files in Excel

[SaurabhT]

I have an excel sheet which acts as an Index to documents in a folder structure on my system. The excel sheet has path of the documents and links to documents created using HYPERLINK formula. I want to validate the links to check if the referenced documents exist or not.

I really appreciate your effort.

 

[Archies]

check this link:
vba - Check if path to file is correct on Excel Column - Super User

Copy paste the code in VBA Project Explorer module :
<code style="margin: 0px; padding: 0px; border: 0px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; white-space: inherit;">Function FileExist(path As String) As Boolean
If Dir(path) <> vbNullString Then FileExist = True
End Function

Now, go back to your spreadsheet view. Go into any cell and type:
<code style="margin: 0px; padding: 1px 5px; border: 0px; font-size: 13px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; white-space: pre-wrap;">=FileExist(A1)

Hope this helps to meet your requirement.</code>
</code>

 

[SaurabhT]

Thank you @Archies. It works great for file path. It does not work for links but it solves my issue for now.
Thank you so much.