Hyperlinks update with filepath

[mj_bowen]

Hi,

I have several large excel files each with multiple hyperlinks contained within them.
For example,

One hyperlink has the address
hyperlink=F:work/planning/week1.doc

This link would work fine as long as the folder containing the file was located on the F: drive (an external drive).

My question ..I have recently uploaded this folder to a cloud server through googledrive (located at C:googledrive/work/planning/week1.doc. on the drive of my work PC and the my docs folder of my home PC.

My question is how to get the hyperlinks to work regardless of the location of the Google driver folder without having to alter the hundreds of hyperlinks in each file.

Kind regards, Matt

 

[tweedle]

I don't think you're going to be able route them without modifying the links (the physical storage for the file has changed, after all).
Something like this might help update the Address of the hyperlinks.

    Dim hl As Hyperlink
    For Each hl In ActiveSheet.Hyperlinks
        newaddress = Replace(hl.Address, "F:", "C:googledrive")
        Debug.Print "Original:"; hl.Address
        Debug.Print "Update  :"; newaddress
        'hl.Address = newaddress
    Next hl