I have a large spreadsheet that incorporates hundreds of hyperlinks to
documents that are all housed within the same folder. For security, I want
to convert all of the documents to .pdf format then change all of the
hyperlinks so that they no longer reference the .doc files and instead
reference the .pdf files of the same name.

If it were within the main portion of the spreadsheet, I would basically be
doing a "Find and Replace" and with ".doc" and ".pdf"; however, I know of no
such option with regards to hyperlinks (though, naturally, I didn't realize
this until after I linked all of the doc files).

Thoughts?
--
R

Randy,

Try this code:

http://cnx.org/content/m17228/latest/

It should do it for you.

HTH.

"Randaylb" wrote:

I have a large spreadsheet that incorporates hundreds of hyperlinks to
documents that are all housed within the same folder. For security, I want
to convert all of the documents to .pdf format then change all of the
hyperlinks so that they no longer reference the .doc files and instead
reference the .pdf files of the same name.

If it were within the main portion of the spreadsheet, I would basically be
doing a "Find and Replace" and with ".doc" and ".pdf"; however, I know of no
such option with regards to hyperlinks (though, naturally, I didn't realize
this until after I linked all of the doc files).

Thoughts?
--
R