Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #11   Report Post  
Old September 10th 09, 01:15 PM posted to microsoft.public.excel.links
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2009
Posts: 7
Default Hyperlink File Path Changes. Hair loss imminent.

So it looks like its trying to establish a hyperlink to the first
file, rather than fixing the hyperlink of the old one. I can change
the cell contents to match the filenames on en mass if this helps.

  #12   Report Post  
Old September 10th 09, 11:10 PM posted to microsoft.public.excel.links
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 473
Default Hyperlink File Path Changes. Hair loss imminent.

OK, so that was a hyperlink you previously fixed.
I assumed you hadn't fixed any of them.
Try this:

Sub ChangeHype()
Dim WS As Worksheet
Dim H As Hyperlink
For Each WS In ActiveWorkbook.Worksheets
For Each H In WS.Hyperlinks
' change it to start after the last \
If InStr(H.Address,"\")0 Then
Debug.Print H.Address
H.Address = Mid(H.Address,InStrRev(H.Address,"\"))
End If
Next
Next
End Sub

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup



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
Hyperlink to File name and path VBA Excel jlclyde Excel Discussion (Misc queries) 3 February 4th 09 07:24 PM
Export file path from sequel to excel as hyperlink KMiles Excel Discussion (Misc queries) 0 August 3rd 07 02:22 AM
Formula too long - new file path is shorter than old file path - Excel 2003 Greg J Excel Worksheet Functions 1 November 22nd 06 05:16 PM
How do I display the full file path for a hyperlink in Office 2003 Worthy Excel Discussion (Misc queries) 6 June 25th 06 04:19 PM
hyperlink navigation path path wrong in Excel 2003 CE Admin Excel Discussion (Misc queries) 5 January 7th 06 07:47 PM


All times are GMT +1. The time now is 04:44 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017