Forum Discussion
Excel hyperlink changes to local path
Hello all, I have a problem with the path of hyperlinks in an excel file changing. I have a file which has a list of hyperlinks to different drawings, these drawings are stored on the company sharepo...
Thank you, this might indeed be a solution to my problem. Having the base adress in the file will solve my problem. When I click the cell it will go to the desired file.
However a next problem it created. My code now does not recognize the hyperlink, for my code cell.hyperlink.count>0 condition is not met. The code now skips the cells with this new hyperlink in it.
Any suggestions on this?
However a next problem it created. My code now does not recognize the hyperlink, for my code cell.hyperlink.count>0 condition is not met. The code now skips the cells with this new hyperlink in it.
Any suggestions on this?
Nevermind! Rookie mistake, I have it fixed.
thanks for your initial suggestion, think it will help me out!
thanks for your initial suggestion, think it will help me out!
