Is there a way to save all hyperlinked documents in excel?
<p>I know this question has been answered before, but the problem I'm facing is a bit different, and this is why I'm asking for your help :)</p>

<p>So, I'm working with multiple excel files that contain multiple hyperlinks that lead to documents such as Excel files, PDFs, DOCs and sometimes even images. The problem with these hyperlinks is that they are not leading to a "normal" website, but to a special internal software, that in its turn links to a local address on my computer that contatins the desired file. That means that there is no direct link that could be grabbed with a simple VBA code.</p>

<p>Let's have an example, assuming the internal software name is "John":
I see in the Excel documents this link:  John://3434545345/345345345
When I click on it, it opens the file, which is located, for example, in: C:/local/Cutekitten.pdf</p>

<p>After this long intro, my question is: Is there a way to automate the process of saving each document, instead of manually opening it and saving it? Could it be solved with a VBA code? Or does is require a different approach? I was actually thinking to bypass this problem by finding a way to open all hyperlinks at once with VBA, and then maybe find some code (not VBA?) that saves all open documents. </p>

<p>P.S Please keep in mind that I can't download EXE files or any other "suspicious" files due to workplace restrictions.</p>

<p>Any help will be much appreciated,
Thanks! :) </p>