Home |
Search |
Today's Posts |
#11
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Hyperlink to File name and path VBA Excel | Excel Discussion (Misc queries) | |||
Export file path from sequel to excel as hyperlink | Excel Discussion (Misc queries) | |||
Formula too long - new file path is shorter than old file path - Excel 2003 | Excel Worksheet Functions | |||
How do I display the full file path for a hyperlink in Office 2003 | Excel Discussion (Misc queries) | |||
hyperlink navigation path path wrong in Excel 2003 | Excel Discussion (Misc queries) |