Hello experts.

I'm trying to use the edit links and refresh through VBA. I've tried to understand the code by recording the process but unfortunately I don't know how to change it to my needs.

The Path of the new file (including the file name) is located at cell 8,8 and the old file has always the same name but it can appear more than once on the edit links browser window, i.e. two different paths for the same file. I intend to replace it with only the new, so if the old link appears once, I replace it only once, if it appears twice, i replace it twice...

After that, refresh it (i never understood if it automatically refreshes after the source change).

It happens that through the recording, the paths are written in full inside the code, and I do not know how to put it flexible.

Could somebody please help me?