• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Need to change multiple hyperlinks to point to another folder

M

mdest

New Member
I have multiple links numbered 001-240 in a column. These links each point to separate pdf files in the same folder. I have moved these pdf files to a folder underneath called "alignment".


How can I automate the process of changing the path to these files?


Note: original hyperlinks were created by right clicking in cell and selecting file. Formula is not visible.


Thanks, Max
 
Hi, mdest!

I didn't find out how to do it with formulaes, but using a few lines of VBA code you can try this:

http://www.2shared.com/file/3rHFNtG5/Need_to_change_multiple_hyperl.html

Regards!
 
Hi, mdest!

Sorry but 2shared gave me an error and the link doesn't work. Tried to re-upload it but something's wrong. I'll try later.

Regards!
 
You must log in or register to reply here.
Back
Top