Advertisement
Guest User

Untitled

a guest
Sep 22nd, 2014
231
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.77 KB | None | 0 0
  1. Sub test()
  2. Dim hLink As Hyperlink
  3. Dim wSheet As Worksheet
  4. Dim path As String
  5.  
  6. For Each wSheet In Worksheets
  7. For Each hLink In wSheet.Hyperlinks
  8. path = Right(hLink, Len(hLink) - 11)
  9. hLink.Address = "\mysrv003" & path
  10. Next hLink
  11. Next
  12. End Sub
  13.  
  14. path = Left(hLink, 11) ' throws error: Object doesn't support this property...
  15.  
  16. path = Mid(hLink.Address, 12) ' returns "somepathdocuments.doc"
  17. ' or, equivalently:
  18. 'path = Right(hLink.Address, Len(hLink.Address) - 11)
  19.  
  20. Sub test()
  21. Dim hLink As Hyperlink
  22. Dim wSheet As Worksheet
  23.  
  24. For Each wSheet In Worksheets
  25. For Each hLink In wSheet.Hyperlinks
  26. hLink.Address = Replace(hLink.Address, "\mysrv001", "\mysrv002")
  27. Next hLink
  28. Next
  29. End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement