Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default How to change multiple hyperlinks at the same time

I have a spreadsheet that contains a long list of objects. Each object is
hyperlinked to a PDF file in a specific sub directory. I need to move the sub
directory with the pdf files in it - I would like to be able to change just
the "pointer" to the sub directory rather than changing EACH hyperlink. Is
this possible?
i.e hyperlink is to c:\mypdfs\001.pdf
I want to change just the address - from "c:\mypdfs" to "c:\newdir\mypdfs
for ALL of the hyperlinks at the same time rather than have to change each
individual hyperlink - is that possible? Any other suggestions?
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Want to update hyperlinks through multiple sheets but can't Billznik Excel Worksheet Functions 1 February 28th 12 07:19 AM
Help with time formula so the time will not change. Joker Excel Discussion (Misc queries) 1 February 17th 06 10:04 AM
change date based on time kdp145 Excel Discussion (Misc queries) 7 December 14th 05 03:05 AM
Time Stamp without change AntonyY Excel Discussion (Misc queries) 3 November 26th 04 10:13 AM
Time Stamp-With Change AntonyY Excel Discussion (Misc queries) 1 November 26th 04 12:38 AM


All times are GMT +1. The time now is 10:43 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"