I have had trouble getting the macro to recognise the opening of the
hyperlink as this is a mouse function.

I appreciate this may be difficult/impossible but i would really like a way
of checking the links without fully opening the file attached .Excel carries
out a limited version of this when warning of opening hyperlinks (the error
message for asking whether you want to open the hyperlink is different to the
one telling you that the address is invalid)

Opening all of the 3000+ files at once would probably kill my PC.

the files the hyperlink refers to are dynamic and change week to week (from
a library of over 40,000)

"Rafael Guerreiro Osorio" wrote:

I think the only way to do this is to write a VBA macro to cycle through the
hyperlinks and check whether the each reference file exist.

Best, Rafael

"Garbagh" wrote:

I have a large spreadsheet with hyperlinks to files on my system.

I need a way to check that all the links work without going through and
clicking them one at a time (for 3000+ hyperlinks this would be extremely
impractical)