View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Rafael Guerreiro Osorio Rafael Guerreiro Osorio is offline
external usenet poster
 
Posts: 27
Default checking hyperlinks are valid

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)