I noticed recently that when i hyperlink files to an excel sheet excel tends to leave out a good portion of the hyperlink address limiting the hyperlink to only be accessible through the workbook in use, hence if this hyperlink were copied into a different workbook it will not work on that other workbook.
I saw somewhere online that if i add "C:" to the "Hyperlink Base", which is found under file/info, all new hyperlinks created will display full address. This works great for me moving forward but how will i fix the large range of existing hyperlinks that still use the old system?
I decided to resolve this with a macro code that will loop though all the data and only focus on the hyperlinked cell, then it will add the full filename to the existing filepath of the hyperlink.
Below is a code pieced together from various snippets:
The problem i am having is i've noticed that the abbreviated version of the hyperlink is preceded by "..", i believe that this should be omitted by the code if i want the hyperlink to work since i am adding more string text to the hyperlink address.Please Login or Register to view this content.
Any ideas on how to add the aforementioned to the code?
Thanks
Bookmarks