Forum Discussion

Copper Contributor

Feb 13, 2020

Excel rewrites my hyperlinks to sharepoint

Hi, I transfered all my work files to OneDrive and encountered an issue. I use excel spreadsheets for worklist, where I use hyperlinks for pics, drawings etc for each workpiece we are currently w...

excel

don242can

Copper Contributor

Jul 11, 2022

Any solution to this? I have been working on a huge index to link to various files and all of the links just changed to the sharepoint link. I want to open the local file that I linked to, not some online version through a browser. I put so much work into this index, only to have the whole thing destroyed by this.

Fverley1223

Copper Contributor

Jul 11, 2022

don242can unfortunately, I have not seen a resolution to this issue. Sorry to hear it has set you back.

don242can
Copper Contributor
Jul 11, 2022
Fverley1223 thanks for the reply. The links were holding for a few weeks of working on this but suddenly today they all pointed to the sharepoint. Completely defeated now.
- Rod_Horning
  Copper Contributor
  Jul 11, 2022
  don242can
  
  Maybe this will work
  
  Make vCommand a Variant
  Instead of Dim vCommand as String, use Dim vCommand as Variant
  - Rod_Horning
    Copper Contributor
    Jul 11, 2022
    Rod_Horning
    
    Sorry. That didn't work either. My test was with an address that wasn't to long.
- Rod_Horning
  Copper Contributor
  Jul 11, 2022
  Maybe... Dim vCommand as String change to Dim vCommand as Variant
- Rod_Horning
  Copper Contributor
  Jul 11, 2022
  Grrr. Just ran into another EXCEL got you. If the hyperlink address is to long (and I don't know how long is long) then selection.hyperlinks(1).address does not return the full address. Instead it returns ../../ and the right hand portion of the full address.