Find and replace Hyperlinks ???

[hwange]

I have a column of hyperlinks all pointing to various prn files.

Is there a way to find & replace the hyperlinks like I can do with
words on MS word.

I have tried the Find replace in excel 2003 but it doesn't seem to be
looking in the hyperlink itself.

I have had to change the drive that these files are on so just hoping
there's an easier way than re linking all 2,500 links.

If anyone is wondering why I just don't leave them where they are then
this is the problem. After re-installing windows and office, Excel has
changed all these links. They are the same except all the Back slashes
"\" have been changed to Forward slashes "/".

Thanks in advance.

 

[Don Guillett]

something like this maybe . UN tested
for each hy in activesheet.hyperlinks
replace(hy,"/","\")
next
'Replace(expression, find, replace[, start[, count[, compare]]])

 

[hwange]

Thank you for your response to my problem.

In the meantime I solved it by putting the following formula in.

=HYPERLINK(("D:\PRN Files\Misc\"&I2&"\"&A2&".prn"),"Print")

This works fine now and one click on the cell tells the hyperlink to
open my *.prn file.

I2 being the folder and A2 the file name.

One other problem I am faced with is, if it is possible, to make this
hyperlink open a 2nd file from the same formula.

eg

=HYPERLINK(("D:\PRN Files\Misc\"&I2&"\"&A2&".prn"),"Print")

then add something to this like

=HYPERLINK(("D:\PRN Files\Misc\"&I2&"\"&A2&".jpg"),"Print")

rolling them into one click