Links for filepaths too long (+260) fix?

[Alejandro Gombao]

Hello,

I have designed an Index for a repository of documentation in which every cell has a Link to open the corresponding file.

It all works wonderfully until the paths start getting longer, since there are docens of directories and subdirectories deepness.

Is there any way so the link can work even if it's so long?

The error when you click on the link is:

I have also noticed that if I rightclick and open the "modify hyperlink", then copy the link to the file and paste it in my file explorer, it works... So I hope there is some way to bypass the error.

Thank you in advance

 

[Joe4]

Thanks Joe.
It was only meant as an example and thinking that the OP new that. And if not, he/she would learn something what might be a plus.
If you say all of that, what about mentioning that I did not show to dimension all of these as strings.
Your signature says it all. Give a man a perfect code and he'll be happy for as long as no changes are required. Teach him when falling down to get up up and he'll learn something. (Changed to suit the occasion)

Yes, while it is not necessary, declaring the variables would be a good idea too.
I am not sure who you were directing your response to, the original poster, or Adam Gore.
If the original poster, note that the question is a few years old, so I doubt the original poster is still waiting for an answer.
If Adam Gore, that is their first post, so I do not think you can assume anything from that about their depth of knowledge about VBA.

The point is, when posting code, please post good code that will not return errors. You never know who may come across this thread in their searches, looking for answers.
We do not want people saying that the code posted on MrExcel is bad and doesn't work!

 

[jolivanes]

You're right on both Joe.
I had not noticed that the Post was a couple years old. I will look after the second also.
I should not have posted directly without, what I normally do, have it in a module first.