View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bgpdis
 
Posts: n/a
Default edit excel pdf hyperlink using find replace

How do I globally change the hyperlinks set up in an excel worksheet - master
file? The hyperlinks have changed folder .pdf to another location when I've
separated invoice scanned .pdf files into years.
Thus I've broken the hyperlinks & wonder if I can quickly change the file
strings to incorporate the additional \Worksheets-year string here before
\Worksheets 2005\
Thanks