RicksAtWork
Programmer
I have a work sheet which contains a bunch of links.
These have been created via:
targetWorkSheet.Hyperlinks.Add Anchor:=Range(cl.Address), Address:=ThisWorkbook.Name, SubAddress:="Data!" & cl2.Address
This works fine.
However, when the data in this sheet is copied to a new work book, the links no longer work, because the links contain the name of the old workbook. Is there a way of updating this links via vba?
These have been created via:
targetWorkSheet.Hyperlinks.Add Anchor:=Range(cl.Address), Address:=ThisWorkbook.Name, SubAddress:="Data!" & cl2.Address
This works fine.
However, when the data in this sheet is copied to a new work book, the links no longer work, because the links contain the name of the old workbook. Is there a way of updating this links via vba?
